Hi new guy here!
I have a bunch of spreadsheets which are all in the same format, I want to take the same data from each file and consolidate in one spreadsheet.
Just need data from two cells, the date (J7) and the result (H16), I've attached a sample file
Is it possible to automate this using a macro or something?
Appreciate any help on this
Thanks