Hi all, hoping that someone will be able to point me in the right direction! I'm having some issues trying to create a macro to loop through each of the criteria options. At the top of my worksheet I have a couple of rows which calculate some figures from the filtered data, and I would like to copy this across to a new sheet with the criteria ID.
The worksheet with the data looks like:
A6:AP6 contains my headings
Column A6 onwards contain the IDs I would like to filter
C1:AP2 contain the rows I would like to copy the values of across to a new worksheet for each ID.
Let me know if you need anymore information, any help would be appreciated!
The worksheet with the data looks like:
A6:AP6 contains my headings
Column A6 onwards contain the IDs I would like to filter
C1:AP2 contain the rows I would like to copy the values of across to a new worksheet for each ID.
Let me know if you need anymore information, any help would be appreciated!