In one worksheet, I have one Table: Table # 1
I have some rows that are colored coded.
I wish to create a second table (Table # 2) to the right of the first table where I wish to extract the rows that have no color.
Question:
How do I extract data from table # 1 on (Left) to table # 2 (Right) in the same worksheet skipping the colored rows.
Is there a macro or a VBA code that will do this?
Right now I am selecting the no color cells one by one.
This will help me automate my task immensely.
Thanks for your help.
Sheela
I have some rows that are colored coded.
I wish to create a second table (Table # 2) to the right of the first table where I wish to extract the rows that have no color.
Question:
How do I extract data from table # 1 on (Left) to table # 2 (Right) in the same worksheet skipping the colored rows.
Is there a macro or a VBA code that will do this?
Right now I am selecting the no color cells one by one.
This will help me automate my task immensely.
Thanks for your help.
Sheela