zero value when copying cells between worksheets

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

Guest

i have a problem copying cells between worksheets in the same workbook. most
of the cells copy and are linked OK but the 2 final columns in the worksheet
table copy and show a zero value. in the formula bar it shows that the cell
is copying the correct data. if you copy the data from a cell that is working
within the same worksheet it just copies the total from the cell and then
when you F2 the cell it shows a xero value. this is difficult to explain but
it seems that most of the worksheet is working OK but the end 2 columns are
acting quite differently.
 
It sounds like you're using Edit|copy, edit|paste special|paste link.

If that's the case, instead of using formulas like:

=sheet2!a1

use a formula like:
=if(sheet2!a1="","",sheet2!a1)
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Macro to copy & paste-special-values data to selected worksheets 1
copying cell contents from one worksheet to another (re-sorted lis 2
Formula returning a blank cell if answer is zero 7
Excel Move or Copy Stopped Working? 0
Excel VBA 1
Creating A List of Items Between Two Numbers 2

Back
Top