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
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
