Coping numbers only in cells to other worksheets.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy Numbers from cells from one worksheet to another using
formula's

I can get the information accross but where there is no numbers on the first
work sheet on the second worksheet it places a 0 in the Cell.

formula 1 =INVOICE!D22 Leaves 0 in the data cell
formula 2 =TEXT(INVOICE!D22,"0") Leaves 0 in the data cell
formula 3 =TEXT(INVOICE!D22,"") Leaves the data cell empty

Can you assist me, Thank you. Regards Bob
 
You can check to see if that first cell is empty.

=if(invoice!d22="","",d22)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assembling Data of Many Sheets in one Summary Sheet 3
Trouble with copy to newly created sheet 5
Runtime error 1004 when trying to insert formula in cells 11
Copying a differing range of rows to a new worksheet 2
Copy a range instead of just one row but with condition 8
Excel Need Countifs Formula Help 0
macro which works in excel 2000 does not work in excel 2002 2
I want the calculated date value of a cell to be the TAB value... 10

Back
Top