Dragging problem in Indirect Function

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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



=INDIRECT("'Sheet1'!C2")



I am not able to shortout this problem please help me


thanks

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
somebody seemed to have given a solution in this newsgroup itself. You have to use a macro given by Tony

https://ccm.net/forum/affich-30063-excel-formulas
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Try this


=INDIRECT("'Sheet1'!C"&ROW(C2))
0