Cutting and Pasteing from One spreadsheet to another.

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
D

Dave Peterson

Select that range to copy.
Edit|replace
what: = (equal sign)
with: $$$$$= (some unique string)
replace all

Now those formulas are just text.

Copy and paste

And then
edit|replace
what: $$$$$=
with: = (some unique string)
replace all

Both in the original worksheet and the pasted worksheet.


Im trying to make up several templates that contain simliar data references.

I want to cut from one template to another a number of cells.
eg I have the following in one spreadsheet.

=Info!G5
=Info!G6
=Info!G7
=Info!G8
=Info!G9
=Info!G10
=Info!G11
etc

I simply want to cut this text exactly as it is and paste it into another
spread sheet.

However when I do I get the following

='C:\Documents and Settings\All
Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G5
='C:\Documents and Settings\All
Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G6
etc.

Referencing the original document. I dont want this. I just want what I have
in my first example. I have tried pasting just formula, but this does not
work. Nothing seems to work. (Im excel 2000).
Can anyone tell me how to do this?

regards
Click to expand...
 
Im trying to make up several templates that contain simliar data references.

I want to cut from one template to another a number of cells.
eg I have the following in one spreadsheet.

=Info!G5
=Info!G6
=Info!G7
=Info!G8
=Info!G9
=Info!G10
=Info!G11
etc

I simply want to cut this text exactly as it is and paste it into another
spread sheet.

However when I do I get the following

='C:\Documents and Settings\All
Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G5
='C:\Documents and Settings\All
Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G6
etc.

Referencing the original document. I dont want this. I just want what I have
in my first example. I have tried pasting just formula, but this does not
work. Nothing seems to work. (Im excel 2000).
Can anyone tell me how to do this?

regards
 
Dave Peterson said:
Select that range to copy.
Edit|replace
what: = (equal sign)
with: $$$$$= (some unique string)
replace all

Now those formulas are just text.

Copy and paste

And then
edit|replace
what: $$$$$=
with: = (some unique string)
replace all

Both in the original worksheet and the pasted worksheet.


Im trying to make up several templates that contain simliar data references.

I want to cut from one template to another a number of cells.
eg I have the following in one spreadsheet.

=Info!G5
=Info!G6
=Info!G7
=Info!G8
=Info!G9
=Info!G10
=Info!G11
etc

I simply want to cut this text exactly as it is and paste it into another
spread sheet.

However when I do I get the following

='C:\Documents and Settings\All
Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G5
='C:\Documents and Settings\All
Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G6
etc.

Referencing the original document. I dont want this. I just want what I have
in my first example. I have tried pasting just formula, but this does not
work. Nothing seems to work. (Im excel 2000).
Can anyone tell me how to do this?

regards
Click to expand...
Click to expand...

Thanks that works great.
 
Back
Top