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
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
- Thank you for the attached. How would I be able to link this to monthly tabs, so if I wanted to select a tab for January this would show me the service dates due in January?
- Well, you do not necessarily need a Jan tab, you could just filter on the date column and choose Jan as the month