Finding Figures On One Sheet and Copying to Another Sheet.

[mlmrob]

Good Morning
I have a spreadsheet and on the first sheet, NH, there are over 20k rows, it increases daily, and in each row is a speed figure for a racehorse and where and when that was achived.
On a second sheet, named Today, I have the list of the horses that are racing that particular day.

At the minute I am transferring the ratings manually, searching the horses name through the filter.

Is there anyway this could be automated through a macro or is the sheet too big.

The link to the sheet is below. I am currently using Office 365.

NH2020_2023.xlsx

Microsoft Excel Workbook

1drv.ms

Thanks and Regards

Rob

 

[mlmrob]

Anyone got an idea?

thanks