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
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
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
Related:
- Copying data in excel -only figures but not formulas
- Number to words in excel formula - Guide
- Display two columns in data validation list but return only one - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
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
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
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