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.
13 freelancers are bidding on average $132 for this job
I viewed all your files: 2017-08-04 at 12.31.42 [url removed, login to view] example finished [url removed, login to view] Example of existing [url removed, login to view] files and the task is a clear for me, I'll code that. Relevant Skills and Experience vba, sql, ado Pr Mais