Sedang Disiapkan

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.

Kemahiran: Pemprosesan Data, Excel, Visual Basic

Lihat lebih lanjut: excel work updated, excel work spreasheet set, excel work powerpoint, excel work ocr, excel work bitcoin

Tentang Majikan:
( 2 ulasan ) Las Condes, Chile

ID Projek: #14841981

Dianugerahkan kepada:

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.

$100 USD dalam 3 hari
(181 Ulasan)
6.7

14 pekerja bebas membida secara purata $129 untuk pekerjaan ini

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 Lagi

$180 USD dalam 3 hari
(189 Ulasan)
7.0
TonmoyRoy111

A proposal has not yet been provided

$70 USD dalam 2 hari
(193 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(22 Ulasan)
5.5
$120 USD dalam 2 hari
(30 Ulasan)
5.1
monettemejo27

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

$155 USD dalam 3 hari
(2 Ulasan)
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 Lagi

$50 USD dalam sehari
(8 Ulasan)
2.9
$100 USD dalam 3 hari
(6 Ulasan)
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 Lagi

$70 USD dalam 2 hari
(2 Ulasan)
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, Lagi

$155 USD dalam 3 hari
(1 Ulasan)
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 Lagi

$30 USD dalam 2 hari
(0 Ulasan)
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 + Lagi

$166 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$264 USD dalam 5 hari
(0 Ulasan)
0.0
Ahaleem123

A proposal has not yet been provided

$100 USD dalam 2 hari
(0 Ulasan)
0.0