Create an Excel Macro
Budget: £20 – £250 GBP
What I am looking is for somebody to create an excel macro that will extract certain data to another worksheet depending on my input criteria.
In the attached spreadsheet you will see groups of data in Columns B to I. These are the horseracing results on a certain date at a certain racecourse. The name of the racecourse is in bold and is always in column C.
I want a macro that when I change the name of the racecourse I want to extract in cell P1 it extracts all of the results for that racecourse into a separate worksheet. I have manually extracted the first few Doncaster results as an example of what I am looking for.
I am aware that the results are not always the same number of rows, therefore to make it easier just extract the first 8 rows for each set of results.
I have attempted it by creating an If statement in column N but then got stuck as to how to extract the data.
In the attached spreadsheet you will see groups of data in Columns B to I. These are the horseracing results on a certain date at a certain racecourse. The name of the racecourse is in bold and is always in column C.
I want a macro that when I change the name of the racecourse I want to extract in cell P1 it extracts all of the results for that racecourse into a separate worksheet. I have manually extracted the first few Doncaster results as an example of what I am looking for.
I am aware that the results are not always the same number of rows, therefore to make it easier just extract the first 8 rows for each set of results.
I have attempted it by creating an If statement in column N but then got stuck as to how to extract the data.