ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   intersection naming transport between files (https://www.excelbanter.com/excel-discussion-misc-queries/96882-intersection-naming-transport-between-files.html)

BorisS

intersection naming transport between files
 
Need the following. I have a model that is used by a customer. I need, once
they finish with it, to apply a sheet which I develop on a test model, which
references different tabs of that model into this €˜ratio analysis sheet.
Because I dont have named ranges in that model, the way in intend to
reference the places that I want to appear on this ratio sheet will be the
entry of line names with column names (for the intersection naming function,
whatever thats formally called). So the question I have is the following€¦if
I make the test case on my model, where I am having sheet names in the
intersection naming, as well as the names of lines and columns (assume the
names dont change from model to model), then when I move my ratio sheet tab
as a copy to the other model, will it still reference the same places on the
new model, or stick to the old model somehow?

Thx.

--
Boris


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com