Numbers will not copy between worksheets

  • Thread starter Thread starter pharrett
  • Start date Start date
P

pharrett

I have an Excel workbook with two worksheets. One named Assests and the
other named Print. Users enter data on the assets sheet and then run a
macro that prints out the 'Print' sheet in a certain way. I have cells
on the Print sheet linked to cells on the Assets sheet with a formula
like this one:

=IF(Assets!B10>"",(""&Assets!B10&""),"")

This works great unless the value entered is just a number. If it's
just a number with no letters, the value from the Assets sheet does not
show in the corresponding cell on the Print sheet.

Anyone have any ideas why this happens? It's XL2k BTW.

Thanks
 
Your formula was testing for a string (used >""), therefore test for empty
cell to return either a value or string.

=IF(ISBLANK()Assets!B10,"",Assets!B10)

Hope this helps. Rob

pharrett said:
I have an Excel workbook with two worksheets. One named Assests and the
other named Print. Users enter data on the assets sheet and then run a
macro that prints out the 'Print' sheet in a certain way. I have cells
on the Print sheet linked to cells on the Assets sheet with a formula
like this one:

=IF(Assets!B10>"",(""&Assets!B10&""),"")

This works great unless the value entered is just a number. If it's
just a number with no letters, the value from the Assets sheet does not
show in the corresponding cell on the Print sheet.

Anyone have any ideas why this happens? It's XL2k BTW.

Thanks


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top