Hi all
i am trying to develop a macro.
the scenario is as follows,,
we have 2 sheets 1 and 2.
i want to apply a vlookup in sheet 1 and the lookup table is in sheet 2.
but in sheet 1 vlookup has to be applied for only those values in column b(for eg)
for which corresponding row in column a has some value.
now problem is if i record a macro by double clikking on cell b1(after applying the vlooku[p in b1) then in the current file it is fine.
but in the macro it records last cell number of column b.(this would be the cell number till which the macro will apply the formula)
so if i run this macro in another sheet in which no. of entries in column b are more there is a problem.
also if no. of entries are less it unnecessary calculates giving value 0.
kindly help
nikhil kumar