hi,
i would like to have the data of one sheet in other excel file.
i left the sheet name but delete all the data and names of it.and put it in
other excel file(lets call it Data file).
i created a macro that open the Data file and copy it to the original
existing tab.
i have #REF problems in other sheets that suppose to use the data. it might
be Naming problem.
do you have an idea how should i solve it?
I tried also to leave the names in the original file. but ref problems still
exist....
--
Miri Tz.