Quote:
Originally Posted by GS[_2_]
Try...
=IF(LEN('[Power Forward 2013.xlsx]1'!$D1),'[Power Forward
2013.xlsx]1'!$D1,"")
...where the row refs are now relative. Copy down to have it work for
other rows.
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public. vb.general.discussion |
Garry,
I need the Rows to remain the same
I have a master spreadsheet. - each line refers to another spreadsheet ('[Power Forward 2013.xlsx]. I am good thus far. the problem is the following number 1' - the 1' refers to a tab in the power forward 2013 spreadsheet. I have 30 tabs labeled 1 2 3 4 5..... exact replicas of one another. what I would like to do is make that 1' automatically change to 2' 3 4 5.
any thoughts?