I am capturing data from next sheet using function formula,however I need to capture about 5000 rows & 20 columns. Need your advice on howI can populate the function formula in the worksheet automatically using VBA.
I can't see what you're getting at. Could you expand onyour question, perhaps give us an example of the formula and explain thedata layout?