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?
Bookmarks