Help to copy data across multiple sheets but leave blank if no data

%3CLINGO-SUB%20id%3D%22lingo-sub-2638583%22%20slang%3D%22en-US%22%3EHelp%20to%20copy%20data%20across%20multiple%20sheets%20but%20leave%20blank%20if%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2638583%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone!%26nbsp%3B%20Hoping%20someone%20can%20help%20me!%26nbsp%3B%20I'm%20no%20expert%20with%20Excel%20whatsoever!%26nbsp%3B%20I%20would%20like%20to%20create%20three%20worksheets%20that%20share%20data%20across%20all%20three%20sheets.%26nbsp%3B%20I'm%20not%20even%20sure%20that%20I'm%20explaining%20this%20well%2C%20but%20here%20goes!%26nbsp%3B%20If%20there%20is%20nothing%20entered%20on%20the%20first%20page%20in%20a%20specific%20column%2C%20for%20example%20one%20column%20is%20date%20completed.%26nbsp%3B%20I%20want%20to%20format%20the%20column%20in%20date%20format%2C%20but%20if%20there%20is%20no%20data%20entered%20as%20the%20project%20is%20not%20completed%2C%20how%20do%20I%20get%20that%20cell%20to%20remain%20blank%20across%20the%20other%20two%20sheets%3F%26nbsp%3B%20I've%20put%20some%20screen%20shots%20below!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone!  Hoping someone can help me!  I'm no expert with Excel whatsoever!  I would like to create three worksheets that share data across all three sheets.  I'm not even sure that I'm explaining this well, but here goes!  If there is nothing entered on the first page in a specific column, for example one column is date completed.  I want to format the column in date format, but if there is no data entered as the project is not completed, how do I get that cell to remain blank across the other two sheets?  I've put some screen shots below!

0 Replies