R
RachuChavan
Hey All,
I have a huge date which is doing lookup. I need to run this lookup only
once. So, I guess i have to write a macro first with lookup and then replace
with ( Edit, Copy, Paste-Special as Value) value correct.
Is there any other way to do this.
If any one of you have a macro please share the same.
Example:
Sheet2
A B
1 Defects Lookup
2 12345 =lookup(A2, Sheet1!A:A, Sheet1!B:B)
3 3457 =lookup(A2, Sheet1!A:A, Sheet1!B:B)
Sheet1 has some date in A and B column.
Acutullay lookups are working absoutely fine only problem as i have a huge
data, when ever I changed some data which is no where related to lookup
colums still it calculates and excel hangs
!! How to speed up this
calculation.
Is there any way i can run only once when excel is open or click on button
or run a macro - and replace with values.
Your effort will be highly appreciated
Raghu
I have a huge date which is doing lookup. I need to run this lookup only
once. So, I guess i have to write a macro first with lookup and then replace
with ( Edit, Copy, Paste-Special as Value) value correct.
Is there any other way to do this.
If any one of you have a macro please share the same.
Example:
Sheet2
A B
1 Defects Lookup
2 12345 =lookup(A2, Sheet1!A:A, Sheet1!B:B)
3 3457 =lookup(A2, Sheet1!A:A, Sheet1!B:B)
Sheet1 has some date in A and B column.
Acutullay lookups are working absoutely fine only problem as i have a huge
data, when ever I changed some data which is no where related to lookup
colums still it calculates and excel hangs
!! How to speed up thiscalculation.
Is there any way i can run only once when excel is open or click on button
or run a macro - and replace with values.
Your effort will be highly appreciated
Raghu