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.

Compétences : Traitement de Données, Excel, Visual Basic

en voir plus : how to make a spreadsheet in microsoft word, how to create a spreadsheet in excel 2010, tableau edit data source, how to do spreadsheets in excel, tableau 9 replace data source, how to create an excel spreadsheet for dummies, how to replace a data source in tableau, how to create an excel spreadsheet with formulas, want to do excel work, need a lawyer to file a case against bank in kolkata, does they need people at excel garage to work, need to create excel file using, do some excel work updated, do some excel work spreasheet set up, do some excel work powerpoint

Concernant l'employeur :
( 3 commentaires ) Las Condes, Chile

Nº du projet : #14841981

Décerné à:


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.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(210 Commentaires)

13 freelance font une offre moyenne de $132 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(212 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(219 Commentaires)

I viewed all your files: 2017-08-04 at 12.31.42 [login to view URL] example finished [login to view URL] Example of existing [login to view URL] files and the task is a clear for me, I'll code that. Relevant Skills and Experience vba, sql, ado Pr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(27 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(31 Commentaires)

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(11 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(8 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

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 + Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)