LinkBack URL
About LinkBacks
Not sure if this will work for you, but you could try using the row number
="'S:\FOLDER LOCATION\FOLDER LOCATION\[223" & ROW() & ".xlsm]Modular'"&"!$S$97"
Not sure if this will work for you, but you could try using the row number
="'S:\FOLDER LOCATION\FOLDER LOCATION\[223" & ROW() & ".xlsm]Modular'"&"!$S$97"
Hi,
Thanks for the reply.
So that works for changing the work sheet numbers for sure.. but excel does not seem to recognise the output as a formula, just text..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks