Copying Columns and rows from one sheet to another EXCEPT color filled and empty

SOLVED:

I had posted this somewhere else but it is really a VBA question. I am trying to write a module that would take all the data from one sheet and populate another sheet, except anything that is color filled or empty. Attached is my Example

I need the data only from FY 18 Detail (not investigators names, totals, deviding black lines etc) to populate FY 18 Detail Combined. I have included a tab (FY 18 Combined EXAMPLE) to show what it should look like. I would need it not to duplicate every time she hits the macro run button.

Thanks

Hello Tgun,

This macro below has been added to the attached workbook. This will selecte only the rows that are not empty and not colored and copy the row to the "Combined Example" sheet. If you change a worksheet's name, you will need to change the name in the macro.

Please Login or Register  to view this content.

Hello Bill,

You're welcome. I hope you learned something new that you can use later on.