I have a macro which copy's the entire Sheet 2 to Sheet 1 based on the headers. But, I would like the code to consider the rows which are highlighted in a specific color.
Example:
Sheet 2 has multiple columns and Sheet 1 will have only 5 or 6 column with headers of Sheet2. With my script, Sheet 1 will pull the complete row; based on the headers from Sheet 2 (Ex: 10). Now, I need to modify the script a bit where it will pull only highlighted(in Red) Rows from Sheet 2 based on the headers(Ex: 2 rows).
Solved by E. Q. in 22 mins