Copying data in excel -only figures but not formulas

Closed
pinhole Posts 1 Registration date Monday July 21, 2014 Status Member Last seen July 21, 2014 - Jul 21, 2014 at 07:43 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 21, 2014 at 07:57 AM
I would like to copy data from one worksheet to the other but do not want the formulas and calculations to pass from one worksheet to the other - just the figures .

The way the first worksheet is made the figures are the result of formulas that should not be exposed in the second worksheet.

Can someone help?

Thanks

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 21, 2014 at 07:57 AM
pinhole, Good morning.

You can do this in a lot of ways.

a) Using formulas
Plan1 --> A1=3 A2=5 A3=A1+A2
Plan2 --> Plan1!A1 Plan1!A2 Plan1!A3
The formula of Plan1 don't show at Plan2

b) Copy and Special Paste
Plan1 --> Select A1:A3
Copy
Plan2 --> Choose the desirable place to put them
Special Paste --> Only Value

c) VBA Code
If you need to copy a lot of data in a specific place, may be a VBA code can help you.

How do you prefer to do this?

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0