I have developed a workbook to show vaious information throughout an entire year. I want this information to be transferred onto a master/cover sheet. I can reference the other worksheets onto it but when I drag the formulas it keeps the reference to sheet 1 all the time. I can manually change the formulas but this could take all week.
Any tips or ideas appreciated
You might consider using INDIRECT but it's Volatile and by the sounds of it that's probably worth avoiding in your model.
Can you post a sample file to better illustrate your requirements ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Attached
I have had to remove some worksheets to keep the file size down.
Manual links would be better IMO but in terms of a quick solution - example:
A10 to A35 etc - enter the cell reference of interest as normal string (K10, K11 etc...)
obviously you will want to adjust some of the above given they are not straightforward links (eg row 33)C10: =IFERROR(INDIRECT("'"&C$9&"'!"&$A10),"") applied to C10:BB35
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
Reply With Quote
Bookmarks