I have an example spreadsheet that contains data across a date range against a list of names on sheet one
I have used index/match to import the cell contents to sheet 2 but I also need to show any comments and cell colours.
This isn't possible using index match but I believe it is with VBA. I would like it to work when the data updates....so the formatting changes corresponding to the data.
Example attached
Many thanks
Simon
[ATTACH]n1204148[/ATTACH]