Need to edit/modify an excel file. Much more work to come!
-Create NEW MASTER PRODUCT NAME Combining various Columns/Fields (Macro or Formula)
-Flip/Invert values (Macro or Formula)
-Highlight Item Type Fields (Conditional Formating)
-Change values (example 6X6 to 6 x 6) …note the spaces (need continuity)
1. Create NEW MASTER PRODUCT NAME Combining various Columns/Fields (Macro or Formula)
-Combine Product Name (Item Type = PRODUCT Name)
Combine SKU - Item Type (measurements) = numeric)
Append abbreviation mm (millimeters) on all numeric measurements in PRODUCT NAME COLUMN
2. Flip/Invert values (Macro or Formula)
Invert/ Flip Pricing from RULE (Item Type = SKU Name) to match above fields. There is no matched SKU but the values are in a REVERSED order)
3. Highlight Item Type Fields (Conditional Formating)
Highlight JUST Item Type PRODUCT Rows in Orange
-First 50 fields are completed as a reference
-Ignore existing hidden Fields
In the Column Item Type:
PRODUCT NAME are MASTER Descriptions
SKU are actual Products
RULE rows have the same data BUT INCLUDE prices AND are INVERTED (highlighted in Yellow, can be deleted after)
NOTE: Product (item Type Price CAN BE DELETED)
10,000 plus rows
Screen shot included.
Example of final result
2 days to finish
More $$ for updated or tweaking.
Hello, I’m an Excel/ VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.