I have a formula that references a sheet in a workbook. I want to copy the formula and increase the sheet number, but keep the same cell reference/rest of the formula. For example, formula = '1'$F34. I want to copy and paste to the right and have it automatically change to '2'$F34. Is there a function that will do this?
You can use INDIRECT but it's Volatile (see link in sig. for more info.)
Assume first formula is in A1:
when copied to the right B1 will reference '2'!F34, C1 will reference '3'!F34 etc...
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks