Insert New Column Based Upon Unique Values

[kasperblue]

Hello,

In my first worksheet "sheetA" I have a list of names in column B. I then have a list of dates from column O to CK in row 4.

The dates in row 4 are the last 75 days of sales.

The data in the second worksheet "sheetB" has the updated sales - a combination of names and dates.

I need a macro to look at the "sheetB" and add each unique date value in date order to the columns to the right of the existing 75 dates, and then remove the initial few columns (depening on how many new columns are added) so there will always end up witn only 75. There could be 5 unique dates to add or only 1 etc depening on when the sales data is refreshed.

I will then use a countifs formula to match the names and the dates from "sheetA" from the values in "sheetB" to keep my sales data up to date.

I have attached an example - hopefully this will explain what i mean more clearly.

Can anyone help with this macro please?

Many thanks