I have attached a sample workbook. It contains a summary tab and other tabs that contain data. What I require is a formula or code that will take the information from the first country tab (In this example 'Corporate'), copy all the rows of data into the summary sheet and then look at column E which is a date. The formula/code then has to look at the month in the date and then colour/shade the relevant month cell in that row.
Then the formula code must copy all the data from the next tab and paste it in the summary sheet directly under the first set of data that was previously pasted. It then needs to repeat the process of looking at the date and colouring/shading the relevant month cell in the row and so on and so forth.
I have no idea where to even start with this so any and all help extremely appreciated.
Ket, London (UK)