Hi all,
I have a spreadsheet that I need to copy some specific data from and paste it to a new sheet. Column A has dates of events, column F has the expected number of attendants, column G has the actual number of attendants. There is a lot of other info that I don't need. The data I need is all in the same row and has a darker blue fill color. I would like a macro that would scrub the sheet finding all rows of that color and copy those rows to a new sheet.
I think that the fill color would be the best condition to use but if you think there is a better one please go for it. It could be finding a specific date format in column A then selecting that row to copy.
Here is an example of the data. Please let me know if you have any questions. If anyone can help it would be greatly appreciated!
Thank you!
I have a spreadsheet that I need to copy some specific data from and paste it to a new sheet. Column A has dates of events, column F has the expected number of attendants, column G has the actual number of attendants. There is a lot of other info that I don't need. The data I need is all in the same row and has a darker blue fill color. I would like a macro that would scrub the sheet finding all rows of that color and copy those rows to a new sheet.
I think that the fill color would be the best condition to use but if you think there is a better one please go for it. It could be finding a specific date format in column A then selecting that row to copy.
Here is an example of the data. Please let me know if you have any questions. If anyone can help it would be greatly appreciated!
Thank you!