Numbers will not copy between worksheets

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
 
S

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

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
Click to expand...
creating financial statements
 
Top