Hello all,
Bit of a tough one here which has me stumped - but there is an attached spreadsheet to help.
I require a macro to automate the data to be populated in the main table in the attached file, populated with the data from the "Data to Import" sheet.
I am looking at where the date in column A and the XXXXX number in G5 (OR H5, I5, J5, K5 etc - as it may be up to AJ5) matches the date in the data from the "Data to Import" sheet.
The table will vary in size, as there could be anything from 2 dates to 365 dates - so it will need to be dynamic on columns A and then from Column G onwards, when looking in row 5 and then completing the table.
If there are multiple matches, then to complete the cell with commas in between each value.
In the "How I want my table to look" tab, it shows that where G5 matches the date in A6, there are 3 instances where there is a match so all three locations are shown in the cell in G6. If there are no matches then the cell is 'Greyed out' as shown in the "How I want my table to look" tab.
Many thanks,
Chris
Bookmarks