Numbers will not copy between worksheets

[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

 

[Sara Jane]

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

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

creating financial statements