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

$30-250 USD

Selesai

Dibuat

hampir 7 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim

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.

Data Processing

Excel

Visual Basic

ID Proyek: 14841981

Tentang proyek

13 proposal

Proyek remot

Aktif 7 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan 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

4,9

(210 ulasan)

6,8

13 freelancer menawar dengan rata-rata $132 USD 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 experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $180 USD - payment once project delivered

$180 USD dalam 3 hari

4,9

(212 ulasan)

7,2

@TonmoyRoy111

A proposal has not yet been provided

$70 USD dalam 2 hari

4,9

(219 ulasan)

6,3

@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, MFC, C++, Java, Python, Android Camera, face detection, alpr, OCR and Wordpress, Shopify, Woocmmerce Website building. I have a working experience in web user controls, master pages, css files using technologies like AJAX Toolkit, JQuery, JavaScript, XML, HTML, JSON, Bootstrap, Angular js and PHP. So that i have also good skills in Web scrap using VBA and (c#, vb). .Net, ASP.Net (MVC) also. When working on a new project, i like to speak with my clients so that i can have a clear understanding of their needs and vision of the project. Thank you in advance for your time and consideration. I look forward working with you soon.

$155 USD dalam 3 hari

4,4

(11 ulasan)

4,4

@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 time limit. Relevant Skills and Experience Excel - 4 years Proposed Milestones $50 USD - Excel work

$50 USD dalam 1 hari

4,7

(15 ulasan)

3,8

@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

5,0

(3 ulasan)

3,3

@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 exchange of a fair rate that is perfectly adjusted to your budget. Htos propuestos $70 USD - To redesign some Excel spreadsheets

$70 USD dalam 2 hari

4,7

(8 ulasan)

2,6

@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 Experience Data Entry, Excel Proposed Milestones $30 USD - Data Entry

$30 USD dalam 2 hari

0,0

(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 +15 years experience in using Excel in professional settings, mostly as Planner/Analyst for well-known companies such as Prada, Giorgio Armani, etc. Very comfortable with macros & formulas. Proposed Milestones $30 USD - 20% deposit in good faith $166 USD - Completion & submission of Excel project as specified in contract Additional Services Offered $100 USD - Build Access database (cross-platform Excel/Access) for ease of continuous large-scale data mining. Thank you for this opportunity. Looking forward to hearing from you. +62 818 09246699 mobile

$166 USD dalam 2 hari

0,0

(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 solving complex problems. We have Experienced Customer Service Representative with demonstrated history of working in industry.(S.P)

$264 USD dalam 5 hari