1 Attachment(s)
Format transfer to sheet 2 after match in sheet1
Dear,
I'm trying to create a warehouse heatmap within the following sheet structure.
- Data Sheet "DATA_Simplified_Loc"
- Holds the location names in column A
- Holds a sum of total picks in column H
- Column H has 3-color scale conditional formatting
- Visualisaton Sheet "GROUND"
- Holds a warehouse layout with the same location names as in sheet "DATA_Simplified_Loc" column A
Goal:
- When running script
- If location name matches --> take conditional formatting from sheet "DATA_Simplified_Loc" column H (same row as match) and transfer to location name cell in sheet "GROUND"
I've attached the Excel as I am failing to succeed with the code.
Thank you.