Hello, I'm somewhat new to forums so please bare with me. I tried finding a thread with a similar issue, but I don't know enough about macros to tailor someone else's solution to my own. For the life of me, I can't seem to find where to upload a sample workbook so I've attached a couple images for reference. These are only a small portion of the typical workbook.
The images represent the desired, end result.
At the beginning of the day both sheets have no colored cells and Sheet2 will contain no data. Sheet1 typically has 60-80 entries between it's two tables, and Sheet2 would normally contain 10 "Trucks" - I have shortened the sheets for the purpose of the thread. I am only trying to color rows that span across C:F and K:N in Sheet1.
I would like to be able to copy the desired data from Sheet1, let's say C3:F3, and paste it to Sheet2 at (in this case) D16:G16 - then have only the original cells from Sheet1 (C3:F3) match the color of the corresponding "Truck" cell in Sheet2 (D15 - light yellow).
I somewhat achieved my desired result using copies of tables in conjunction with =MATCH conditional formatting, however, I could only effectively use the "Address" columns, as they are the only consistently unique data in the four-column rows. Even if it had worked, it would not have been ideal because it would require a conditional format for each truck in each cell, each of which would then transfer to Sheet2 when I paste. This leads me to believe a macro is the best solution, but macros are not something I have any experience with.
Any help is sincerely appreciated!
Sheet1 https://drive.google.com/open?id=0B-IDHBGdi___SFdWZVMya1EwY2M&authuser=0
Sheet2 https://drive.google.com/open?id=0B-IDHBGdi___cktaNW9MLUM5VTg&authuser=0
The images represent the desired, end result.
At the beginning of the day both sheets have no colored cells and Sheet2 will contain no data. Sheet1 typically has 60-80 entries between it's two tables, and Sheet2 would normally contain 10 "Trucks" - I have shortened the sheets for the purpose of the thread. I am only trying to color rows that span across C:F and K:N in Sheet1.
I would like to be able to copy the desired data from Sheet1, let's say C3:F3, and paste it to Sheet2 at (in this case) D16:G16 - then have only the original cells from Sheet1 (C3:F3) match the color of the corresponding "Truck" cell in Sheet2 (D15 - light yellow).
I somewhat achieved my desired result using copies of tables in conjunction with =MATCH conditional formatting, however, I could only effectively use the "Address" columns, as they are the only consistently unique data in the four-column rows. Even if it had worked, it would not have been ideal because it would require a conditional format for each truck in each cell, each of which would then transfer to Sheet2 when I paste. This leads me to believe a macro is the best solution, but macros are not something I have any experience with.
Any help is sincerely appreciated!
Sheet1 https://drive.google.com/open?id=0B-IDHBGdi___SFdWZVMya1EwY2M&authuser=0
Sheet2 https://drive.google.com/open?id=0B-IDHBGdi___cktaNW9MLUM5VTg&authuser=0
