Need to edit/modify an excel file. Much more work to come!

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.

Taidot: tietojenkäsittely, Excel, Visual Basic

Näytä lisää: excel work updated, excel work spreasheet set, excel work powerpoint, excel work ocr, excel work bitcoin

About the Employer:
( 2 reviews ) Las Condes, Chile

Projektin tunnus: #14841981

Myönnetty käyttäjälle:


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.

100 $ USD 3 päivässä
(181 arvostelua)

14 freelanceria on tarjonnut keskimäärin 129 $ tähän työhön


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Lisää

180 $ USD 3 päivässä
(189 arvostelua)

A proposal has not yet been provided

70 $ USD 2 päivässä
(193 arvostelua)

I viewed all your files: 2017-08-04 at 12.31.42 AM.png example finished File.xlsx Example of existing File.xlsx files and the task is a clear for me, I'll code that. Relevant Skills and Experience vba, sql, ado Pr Lisää

250 $ USD 3 päivässä
(22 arvostelua)
120 $ USD 2 päivässä
(30 arvostelua)

I have 8 years of Data Entry experienced. Relevant Skills and Experience Data Entry & quickbooks Proposed Milestones $155 USD - 3 days

155 $ USD 3 päivässä
(2 arvostelua)

I have seen your screenshots and files. I have good experience in similar kind of work in excel. I have developed different visualizations to analyze the data in Excel.I can complete the task flawlessly and within the Lisää

50 $ USD 1 päivässä
(8 arvostelua)
100 $ USD 3 päivässä
(6 arvostelua)

Hi. I`m bidding for this project because I am a professional with lot of experience in MS Excel. Habilidades y experiencia relevante I guarantee you an accurate job, proper formatting and fast delivery; all this in ex Lisää

70 $ USD 2 päivässä
(2 arvostelua)

I am from china as a specialist, good in Desktop, Mobile and Website building and 5 years development experience. And I am experienced in Desktop and Web development with Microsoft technologies using C#, WPF , UWP, Lisää

155 $ USD 3 päivässä
(1 arvostelu)

I am a professional having more than 8 years experience. Have done Data entry and SWOT analysis on Freelancers. I am an Excel & Word Expert and can do work with speed and accuracy. Thank You Relevant Skills and Experi Lisää

30 $ USD 2 päivässä
(0 arvostelua)

Hi, my name is Wes & I have +15 years experience in Excel usage, mostly in the Fashion industry. I have worked as planner/analyst at Prada, Armani, Brioni, Kenneth Cole, John Varvatos. Relevant Skills and Experience + Lisää

166 $ USD 2 päivässä
(0 arvostelua)

We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning. The Dynamic force has qualified engineers having expertise in Lisää

264 $ USD 5 päivässä
(0 arvostelua)

A proposal has not yet been provided

100 $ USD 2 päivässä
(0 arvostelua)