Sharing data between worksheets
I'm sharing data between two worksheets, but if a cell is blank on the master
worksheet, how to I get a blank cell on the linked worksheet? It automatically pulls up a bogus date (i.e. 1/00/00). Is there a way to tell it to leave the cell blank, but still have it linked? help please.... Thanks! |
Sharing data between worksheets
Try something like this:
=IF(Master!A1="","",Master!A1) -- Biff Microsoft Excel MVP "JessJohns" wrote in message ... I'm sharing data between two worksheets, but if a cell is blank on the master worksheet, how to I get a blank cell on the linked worksheet? It automatically pulls up a bogus date (i.e. 1/00/00). Is there a way to tell it to leave the cell blank, but still have it linked? help please.... Thanks! |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com