Forum Discussion
Linking data from master sheet into monthly date tabs
I have a excel sheet with a mixture of dates and text and trying to link the dates into month tabs from January to December
6 Replies
Karen281910 The first step you need to take is to make sure Excel recognizes each date as a true date. Any "date" that is left-aligned, isn't recognized as a date by Excel. Currently only about 290 of the almost 1600 cells in the Date columns contain a valid date.
If your data would have been structured like this:it would have been far, far easier to setup a page on which you can simply select a period to see all activity in that period. Or to just filter the above table on the (single!) date column and on the Building column for example.
Thank you for reply, out of interest how did you format the structure in the example given?
Karen281910 Attached is a file where I used Data, Get Data to transform the table into the structure I would suggest to use
