Previous Topic Next Topic

Dragging problem in Indirect Function

Closed
Manjeet Singh - Apr 22, 2010 at 01:41 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 22, 2010 at 06:20 AM
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
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 22, 2010 at 05:57 AM
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
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 22, 2010 at 06:20 AM
Try this


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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses