Hi all, I'm note sure if this at all possible in excel but I'll give it a go.
I have a table of data (Columns A-T) that updates daily and columns U-EC are all date fields (the start of each working week ie mondays)
In the spreadsheet column T has a date in each row. Each row is a different part.
What I would like to know is , can the value that appears in say "T2" be plotted in the column that that date falls into (columns U-EC )
ie cell T2 is data "20/06/19" , look across the next columns and put an "X" or copy the date into the column the working week it falls in for that row.
Appreciate there must be an easier way of doing this, but its the only way i can explain what I need.
Thank you
I have a table of data (Columns A-T) that updates daily and columns U-EC are all date fields (the start of each working week ie mondays)
In the spreadsheet column T has a date in each row. Each row is a different part.
What I would like to know is , can the value that appears in say "T2" be plotted in the column that that date falls into (columns U-EC )
ie cell T2 is data "20/06/19" , look across the next columns and put an "X" or copy the date into the column the working week it falls in for that row.
Appreciate there must be an easier way of doing this, but its the only way i can explain what I need.
Thank you
