Copying Data From A Cell In One Spreadsheet to A Cell In Another

**DharmeshChauhan** · 12-09-2022, 07:39 AM

Hi

I currently have two spreadsheet, one which is sent to us from our client and the other is my own template

When we receive this file from the client I copy the whole spreadsheet and paste it in a new tab (called JML) on my template spreadsheet

I am copying cells data from the JML tab on to where i would like it on my own template

To do this i am using the formula =JML!L3

But if a cell in the JML tab does have any data, then formula in my template is showing 0, how do i remove this or make this cell blank if no data is found in the JML tab

JML.PNG

**rollis13** · 12-09-2022, 09:50 AM

This could be a solution:

=IF(JML!L3<>"",JML!L3,"")

**iammike** · 12-10-2022, 04:12 AM

or you can use this

Hide or display all zero values on a worksheet

Click File > Options > Advanced.
Under Display options for this worksheet, select a worksheet, and then do one of the following:
To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

or

Hide zero values in selected cells

These steps hide zero values in selected cells by using a number format. The hidden values appear only in the formula bar and are not printed. If the value in one of these cells changes to a nonzero value, the value will be displayed in the cell, and the format of the value will be similar to the general number format.

Select the cells that contain the zero (0) values that you want to hide.

You can press Ctrl+1, or on the Home tab, click Format > Format Cells.
Format Cells on the Home tab
Click Number > Custom.
In the Type box, type 0;-0;;@, and then click OK.

or

Hide zero values returned by a formula

Select the cell that contains the zero (0) value.

On the Home tab, click the arrow next to Conditional Formatting > Highlight Cells Rules Equal To.

In the box on the left, type 0.

In the box on the right, select Custom Format.

In the Format Cells box, click the Font tab.

In the Color box, select white, and then click OK.

Link: https://support.microsoft.com/en-us/...5-a00e9e476b03