Hello,
Want to know if the below type of linking is possible in excel.
All my excel workbooks have a pricing worksheet with all other worksheets referring to the Pricing worksheet for values.
How to I link the sheets such that when the worksheet is moved to another workbook, it refers to the pricing from the pricing sheet of the new workbook and not stay linked to the old one.
if the above question is not clear, writing another example below.
Workbook A has worksheets WS1 & WS2.
All values of WS2 come from WS1.
When WS2 is moved to new workbook B which already has a different WS1 for reference of values, WS2 should refer to WS1 in Workbook B for values.
(Note : WS1 is a standard format in all workbooks)
What formula should I use to link WS1 & WS2 so that this is possible?
Bookmarks