corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help - Indirect function


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Help - Indirect function
antnee
Member

Registered: 30th Dec 07
Location: Cov Drives: Clio 197
User status: Offline
17th Jul 13 at 22:12   View User's Profile U2U Member Reply With Quote

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

Avatar

Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
17th Jul 13 at 22:18   View Garage View User's Profile U2U Member Reply With Quote

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

Avatar

Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
17th Jul 13 at 22:27   View Garage View User's Profile U2U Member Reply With Quote

=INDIRECT("Sheet1!A"&ROW(A5))
Matt L
Member

Registered: 17th Apr 06
User status: Offline
18th Jul 13 at 12:43   View User's Profile U2U Member Reply With Quote

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
18th Jul 13 at 12:59   View User's Profile U2U Member Reply With Quote

Tested Robs response, seems to do what the OP wanted.
antnee
Member

Registered: 30th Dec 07
Location: Cov Drives: Clio 197
User status: Offline
18th Jul 13 at 17:24   View User's Profile U2U Member Reply With Quote

Robs has worked spot on! Although I have changed what I am doing now so don't need it exactly

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
is there a program that...... chris_uk Geek Day 6 1893
16th Jun 05 at 00:47
by Dan B
 
Excel Help AndyKent Geek Day 3 1451
6th Oct 07 at 10:22
by aPk
 
Microsoft Excel strick206 Geek Day 16 860
18th Apr 08 at 16:26
by strick206
 
need an excel like programme (for free) Shane Geek Day 12 1770
13th May 08 at 14:55
by pow
 
Microsoft Excel strick206 Geek Day 10 1478
6th Jul 11 at 14:46
by Sam
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help - Indirect function 29 database queries in 0.0111160 seconds