Leaving a Copied Cell Blank if no data [Closed]

LLL - Apr 19, 2018 at 05:16 PM - Latest reply: Ambucias 55047 Posts Monday February 1, 2010Registration dateModeratorStatus September 22, 2018 Last seen
- Apr 19, 2018 at 05:25 PM
I have several spreadsheets containing different information on the same patient. Patient is ID a number. The ID has to copy over to several different sheets. I have gotten it to copy with a cut and paste formula. However, if there is no data in the original space (patient number) then a 0 appears in the column on the other sheets. Is there any way to keep the cell blank if the original cell is empty?
See more 

1 reply

Ambucias 55047 Posts Monday February 1, 2010Registration dateModeratorStatus September 22, 2018 Last seen - Apr 19, 2018 at 05:25 PM
0
Thank you
Greetings,

Please, bare in mind that CCM.net is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator