antnee
Member
Registered: 30th Dec 07
Location: Cov Drives: Clio 197
User status: Offline
|
I am trying to use the Indirect function (keeps the cell reference even if rows are inserted) but I need help to find a quick way of reproducing the function/command without having to manually change each cell.
At the moment I have the command =INDIRECT("'sheet1'!a10"), now if I click on the cell this command is in and use the black drag down on the bottom right all the cells below keep looking at cell A10, but I want them to follow on in order (11, 12, 13, etc). Is there a way of doing this without going onto each cell?
|
evilrob
Premium Member
Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
|
Edit: first response deleted as I am a penis and didn't read the problem properly.
[Edited on 17-07-2013 by evilrob]
|
evilrob
Premium Member
Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
|
=INDIRECT("Sheet1!A"&ROW(A5))
|
Matt L
Member
Registered: 17th Apr 06
User status: Offline
|
would the $ sign not work?
so it would be = "sheet1!"$A10 or what ever it is, this would then work if you dragged it down?
tbf not entirely sure on what the indirect function does, so this may be a pointless answer.
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
Tested Robs response, seems to do what the OP wanted.
|
antnee
Member
Registered: 30th Dec 07
Location: Cov Drives: Clio 197
User status: Offline
|
Robs has worked spot on! Although I have changed what I am doing now so don't need it exactly
|