Any help on this would be greatly appreciated, I have this statement here:
=INDIRECT("'" & $B4 & "'!"&"H9")
it works good for one cell of data but I want to drag the formula down to cover several rows, the $B4 goes to $B5 and so on which is what I want, but I can't get the H9 to go to H10 and H11 and so on. I've tried taking it out of quotes but I get a #ref error. I'm stumped, any ideas?
I had no trouble dragging the formula down: =INDIRECT("'" & $B4 & "'!" &H9)
Ben Van Johnson
Try this..
=INDIRECT("'"&$B4&"'!H"&ROW(9:9))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
sixthsense, that worked beautifully! many thanks!
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks