Hi the experts,

I need your help with a VB code that can remove the rows (with any cells background filled in RED color in column A Sheet1)to copy onto Sheet2

If would be even better if the code can also copy the headers name in row 1 to paste onto row 1 in Sheet2.


Thanks in advance for your help.

Don't start new threads before your original one has been answered (unless it's on an entirely different topic), and think before you post the first one. Try to work out what you need, then post the question and any supporting data. Like the fact your range has headers. And you want them on a different sheet.


There are two secrets to success in this world:
1. Never tell everything you know