Transferring data from one sheet to another in Excel
Closed
KKunard
-
Dec 27, 2016 at 03:41 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 27, 2016 at 06:31 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 27, 2016 at 06:31 PM
Related:
- Transferring data from one sheet to another in Excel
- Transfer data from one excel worksheet to another automatically - Guide
- How to screenshot excel sheet - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- Little alchemy cheat sheet - Guide
2 responses
We are a group of volunteeers, so we are not familiar with all that is published here.
Give us the URl from which you cut and pasted, and we should be able to assist in trapping a blank value!
Give us the URl from which you cut and pasted, and we should be able to assist in trapping a blank value!
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 27, 2016 at 06:31 PM
Dec 27, 2016 at 06:31 PM
Hello KKunard,
You may have to introduce an IF statement to clear the "0". As an example:-
The formula basically says: if sheet1 cell A1 is blank, leave a blank otherwise input the A1 value.
I hope that this helps.
Cheerio,
vcoolio.
You may have to introduce an IF statement to clear the "0". As an example:-
=IF(Sheet1!A1="","",Sheet1!A1)
The formula basically says: if sheet1 cell A1 is blank, leave a blank otherwise input the A1 value.
I hope that this helps.
Cheerio,
vcoolio.