Copying data in excel -only figures but not formulas
Closed
pinhole
Posts
1
Registration date
Monday 21 July 2014
Status
Member
Last seen
21 July 2014
-
21 Jul 2014 à 07:43
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 21 Jul 2014 à 07:57
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 21 Jul 2014 à 07:57
Related:
- Copying data in excel -only figures but not formulas
- How to copy data from one excel sheet to another - Guide
- Arrow keys not working in excel - Guide
- Export data from excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Extract data from excel to excel - Excel Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
21 Jul 2014 à 07:57
21 Jul 2014 à 07:57
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
