I have only data in Sheet1 from C2 to C200 and
I am using Indirect function in Sheet2 and when i drag it from C2 to C200 it is showing
only C:2 data in all cell from C2 to C200
I am not able to sort out this problem please help me
You can try this:
Thanks to rizvisa1
for this tip on the forum.