Hi
I'm creating an Excel workbook that contains edited info from another (to send to a third party, so hiding is not an option)
Both are made up of numerous tabs.
My current formula is: ='[Z CONFIDENTIAL MASTER EQUIPMENT LIST.xls]B2 01'!C10
Is there a way to replace the bold tab name in the formula above with a reference to the tab in the new sheet, so that it pulls data from the tab of the same name on the original?
For example, if I create a new tab called C2 01, I want it to copy data from tab C2 01 in Z CONFIDENTIAL MASTER EQUIPMENT LIST.
Hope this makes sense?
I'm creating an Excel workbook that contains edited info from another (to send to a third party, so hiding is not an option)
Both are made up of numerous tabs.
My current formula is: ='[Z CONFIDENTIAL MASTER EQUIPMENT LIST.xls]B2 01'!C10
Is there a way to replace the bold tab name in the formula above with a reference to the tab in the new sheet, so that it pulls data from the tab of the same name on the original?
For example, if I create a new tab called C2 01, I want it to copy data from tab C2 01 in Z CONFIDENTIAL MASTER EQUIPMENT LIST.
Hope this makes sense?