00/01/1900 In the date cell when linked cell is empty?

  • Thread starter Thread starter Derek Peters
  • Start date Start date
D

Derek Peters

Hi I have 52 worksheets all linked up to a total sheet that is working very
well thanks to RD

All I need to do now is sort out the date this is copied from sheet1 onto
the totals page and works fine when the date is put into sheet1.

However if the cell is blank on sheet2 the date is put into the totals sheet
as 00/01/1900 when the date is put in sheet2 all is well with the right date
entered into the totals sheet.

So how do I get the totals date to stay blank until the weekly sheets have a
date put into the sheet please.

the format I am using is below


many thanks for all the help I have had with this project!

Regards
Derek





One approach is to set-up your "Start" sheet with the names of all your
weekly sheets in a column.
Across the rows enter labels for the 20 categories that your interested in
reviewing.

For example, starting in A2 and going down,
Sheet1
Sheet2
Sheet3
.....
Sheet52

Now, say the first cell of interest on *all* the sheets would be C20.
Enter this in B2:

=INDIRECT(A2&"!C20")

Drag down to copy, and you now have all the data from C20 in all 52 sheets.

Whether or not you can drag this formula *across* the columns depends on
exactly which cells on the other 52 sheets you are looking to be returned.

Needless to say, the spelling of the sheets in column A must match exactly
the actual sheet names in the WB.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
So how do I get the totals date to stay blank until the weekly sheets have a
date put into the sheet please.
Click to expand...

You could use a custom format in that cell such that 0's would be blank:

Format/Number/Custom Type: dd-mm-yyyy;;


--ron
 
Back
Top