Devam Ediyor

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

Notes:

-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.

Beceriler: Veri İşleme, Excel, Visual Basic

Daha fazlasını görün: excel work updated, excel work spreasheet set, excel work powerpoint, excel work ocr, excel work bitcoin

İşveren Hakkında:
( 2 değerlendirme ) Las Condes, Chile

Proje NO: #14841981

Seçilen:

P0L

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.

3 gün içinde 100$ USD
(181 Değerlendirme)
6.7

14 freelancer bu iş için ortalamada 129$ teklif veriyor

schoudhary1553

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 Daha fazlası

in 3 gün içinde180$ USD
(189 Değerlendirme)
7.0
TonmoyRoy111

A proposal has not yet been provided

in 2 gün içinde70$ USD
(193 Değerlendirme)
6.1
zu02

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 Daha fazlası

in 3 gün içinde250$ USD
(22 Değerlendirme)
5.5
in 2 gün içinde120$ USD
(30 Değerlendirme)
5.1
monettemejo27

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

in 3 gün içinde155$ USD
(2 Değerlendirme)
3.3
javidj18

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 Daha fazlası

1 gün içinde 50$ USD
(8 Değerlendirme)
2.9
in 3 gün içinde100$ USD
(6 Değerlendirme)
2.5
ReneRondon

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 Daha fazlası

in 2 gün içinde70$ USD
(2 Değerlendirme)
1.5
polarjin2017

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, Daha fazlası

in 3 gün içinde155$ USD
(1 Değerlendirme)
1.4
FawadSidd

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 Daha fazlası

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
wesyahatadji

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 + Daha fazlası

in 2 gün içinde166$ USD
(0 Değerlendirme)
0.0
MetaoriginLab

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 Daha fazlası

in 5 gün içinde264$ USD
(0 Değerlendirme)
0.0
Ahaleem123

A proposal has not yet been provided

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0