merken
12-10-2019, 04:48 AM
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.
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.