ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Referencing Cells on Another Sheet (https://www.excelbanter.com/excel-worksheet-functions/173963-referencing-cells-another-sheet.html)

PAL

Referencing Cells on Another Sheet
 
I have 6 cells going across rows:

F2 is a text box
G2 is a date
H2 is a date
I2 is a text box
J2 is a text box

When I reference these cells:
if there is not a value in the text box to copy over, I get 0 in the "new
cell".
if there is not a value in the date box, I get 0-jan-00.

I have to reformat the new cells each time, which is a drag....Is there any
way to reference them and not have to reformat each time. That is, when they
are blank, not get the 0 for blank text and 0-jan-00 for the blank date.

Thanks.




All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com