Zlerp
09-15-2014, 12:07 PM
Hello,
I am looking to create a macro that will use 2 worksheets in the same macro book. I want the data and format from one sheet to be copied to the other sheet if the values match in column A.
****************************
I do not want colums I,J,K,L,O, or P to be copied
****************************
For example.
in Worksheet 1 I have data in A4:P50 (some cells are highlighted)
in Worksheet 2 i have data in A4:P90
If A7 from worksheet 1 and A12 from worksheet 2 match, I want to copy A7:H7 and M7:N7 (format and all) to A9:H9 and M9:N9.
This should happen for all matching values in the A column from worksheet 1 to worksheet 2.
If the cells don't match the value should stay the same.
P.S. there will be more than 50 rows of data, so i need it to do this until the last row of data.
I am looking to create a macro that will use 2 worksheets in the same macro book. I want the data and format from one sheet to be copied to the other sheet if the values match in column A.
****************************
I do not want colums I,J,K,L,O, or P to be copied
****************************
For example.
in Worksheet 1 I have data in A4:P50 (some cells are highlighted)
in Worksheet 2 i have data in A4:P90
If A7 from worksheet 1 and A12 from worksheet 2 match, I want to copy A7:H7 and M7:N7 (format and all) to A9:H9 and M9:N9.
This should happen for all matching values in the A column from worksheet 1 to worksheet 2.
If the cells don't match the value should stay the same.
P.S. there will be more than 50 rows of data, so i need it to do this until the last row of data.