How do I leave linked cells that do not contain a date

E

elusiverunner

I have two worksheets in the same workbook that contain linked cells, a date.
The ones that contain a date in one worksheet copy the date into the other.
The problem is that if the "main" worksheet has cells with no dates the other
worksheet cells that should be blank fill with the value 00.01.1900 rather
than leave them blank as in the main worksheet.

Also the "secondary" worksheet says each of the cells needs to be locked
which I don't want to happen if I decide to change the date for any reason.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Values in linked Cells Only 4
Sorting non-linked cells in a linked worksheet 1
modify linked cells without breaking link 1
How do I remove zeros from a linked blank cell? 3
Dates linked in Excel files 3
Auto-populate other cells based on dates 2
how to return an address from a lookup into a table? 7
Cells act as if they are linked-link does not display in entry bar 1

Top