Copying sheets from one file to another and keeping the formulas..

[Guest]

I maintain excel sheets that are used as forms that we have clients fill out
to select options. The way we are set up is thus. You have a Collection...
about 10 of them actually, and underneath them are SUB collections we call
Elevations. Now.. the sheets we use are pretty universal, if there's a
sheet for one collection.. there's a different version of that same sheet if
not the same exact sheet in the other collections. To keep from having to
retype or edit all of the formulas i have in them that point to other sheets
in that file (ie. a file named "VillasCFP.xls" with a worksheet named "Color
Selections" that has formulas pointing to another sheet called "OptionsPg1".
If i wanted to copy the "Color Selections" sheet and paste it or move it to
another file, say for example "MiddleburgsCFP.xls", could i get it to go into
the middleburg file without the formula then reading
"[villascfp.xls]'optionspg1..." bla bla bla) there IS a sheet in the
destination file with the exact same worksheet name (optionpg1).

 

[Frank Kabel]

Hi
you could use for pasting the data
'Edit - Paste Special - Values'

--
Regards
Frank Kabel
Frankfurt, Germany

"Excel Grasshoppah" <Excel (e-mail address removed)>
schrieb im Newsbeitrag
news:[email protected]...

 

[Guest]

wouldn't that eliminate the formulas?

Hi
you could use for pasting the data
'Edit - Paste Special - Values'

--
Regards
Frank Kabel
Frankfurt, Germany

"Excel Grasshoppah" <Excel (e-mail address removed)>
schrieb im Newsbeitrag

I maintain excel sheets that are used as forms that we have clients fill out
to select options. The way we are set up is thus. You have a Collection...
about 10 of them actually, and underneath them are SUB collections we call
Elevations. Now.. the sheets we use are pretty universal, if there's a
sheet for one collection.. there's a different version of that same sheet if
not the same exact sheet in the other collections. To keep from having to
retype or edit all of the formulas i have in them that point to other sheets
in that file (ie. a file named "VillasCFP.xls" with a worksheet named "Color
Selections" that has formulas pointing to another sheet called "OptionsPg1".
If i wanted to copy the "Color Selections" sheet and paste it or move it to
another file, say for example "MiddleburgsCFP.xls", could i get it to go into
the middleburg file without the formula then reading
"[villascfp.xls]'optionspg1..." bla bla bla) there IS a sheet in the
destination file with the exact same worksheet name (optionpg1).

 

[Stevethedoc]

check the edit, paste special route.

when window pops up choose Values and then OK for data
immediately return to edit,paste special and select formula
click Ok and then go to edit paste special and choose format

this is close to a standard paste.
Alas you have to choose individual items ffrom the window each time