Find Jobs
Hire Freelancers

Excel spreadsheet help CATEGORY

£10-20 GBP

Dokončeno
Zveřejněno přibližně před 6 roky

£10-20 GBP

Zaplaceno při doručení
HI there i need somebody who can run a formula to import the category id and category parent number's and match them with the category names from 2 different spreadsheets. I have an existing master excel spreadsheet that i use for categories to populate my website. I now have a new spreadsheet with more categories - that i need to match up with the existing sheet. I require an excel expert to help create 2 new columns in the new spreadsheet for the categories to import the relevant matching numbers from the existing spreadsheet. this will involve using data from 2 seperate spreadsheets There are some categories that will be new and will not exist on the master spreadsheet. they should still import the relevant NUMBER to match the category PARENT ID - but leave the category id blank (as its a new category) master spreadsheet has the numbers in 2 columns : Category ID and Parent ID this is the second help i require on the spreadsheet there will be many more projects. Thanks
IČ projektu: 16104916

O projektu

42 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Creating a formula to import the category id and parent id and match them with the category names from two different spreadsheets. Relevant Skills and Experience Data Processing, Formulas, Excel, Algorithm, Visual Basic. Proposed Milestones £15 GBP - Formula as described If possible, please share the actual documents. Thanks, Milan
£10 GBP v 0 dni
5,0 (395 recenze)
6,7
6,7
42 freelanceři nabízejí v průměru £17 GBP za tuto práci
Avatar uživatele
HI, I am good at Excel and vba. I can transfer the data from one sheet to another sheet. I have reviewed the attachments. Looking forwarrd to discuss in the chat. -Chandra Relevant Skills and Experience Excel, vba, Macros Proposed Milestones £20 GBP - Milestone
£20 GBP v 0 dni
5,0 (714 recenze)
7,7
7,7
Avatar uživatele
Read your specs and can do this task with ease. Please opem discussion Relevant Skills and Experience Excel Proposed Milestones £50 GBP - Excel
£50 GBP v 1 dni
5,0 (393 recenze)
7,3
7,3
Avatar uživatele
Hi, I have done the work. Just pay me and get the macro instantly. Please contact via chat, so that I can send you screen shots of finished work. Thank you. Regards, R.Haresh. Relevant Skills and Experience Excel Proposed Milestones £10 GBP - To get the formulas
£10 GBP v 1 dni
5,0 (25 recenze)
7,2
7,2
Avatar uživatele
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Relevant Skills and Experience I am an excel/word/outlook VBA automation professional having 7+ years of experience. Lets discuss more online on chat. Thanks, A Proposed Milestones £21 GBP - 1
£21 GBP v 1 dni
4,9 (160 recenze)
6,5
6,5
Avatar uživatele
Hi, I am interested to work with you. I have 76 review with 5 start feedback, you may visit my profile. So just give me this project and be happy. Relevant Skills and Experience Excel, Vba Proposed Milestones £16 GBP - Project
£16 GBP v 1 dni
5,0 (69 recenze)
5,7
5,7
Avatar uživatele
Hi, I can work out on your requirement. Kindly text me for further details. Regards
£18 GBP v 1 dni
4,8 (32 recenze)
5,2
5,2
Avatar uživatele
I have 04+ Years experience in this field with 100% of success ratio and 300 project has completed. Delivering top-level services is my speciality . Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones £18 GBP - Full create the milestone I believe that my expertise would be a good match for your project. Ready to start. I have completed many project and I read your description carefully and understand all your requirements. I am expert Image Editing, Photo Editing, Photo retch, Photo Background removed,transcribe an audio file ,Data Entry, Excel, Web Scraping, Web Search, Yellow page an,d Yelp Web Scraping PDF to excel, PDF to Word, Image to text, Facebook Marketing, Update template I’m astute, creative, and pay attention to detail. Thank you for your consideration. Shareef Mohd
£18 GBP v 1 dni
4,6 (110 recenze)
5,4
5,4
Avatar uživatele
Greetings, Experienced Excel practitioner here available to start immediately. Have understood the requirements. Have sought couple of clarifications below. Regards. Relevant Skills and Experience Excel, Data Processing Proposed Milestones £15 GBP - Final 1. I presume the "Parent Category Name" is the "Other1" column in "Master Category" sheet (to be matched with "Printer Category" column in "New Category" sheet)? 2. Is this a one time job? Would you like the formulae in "Category ID" and "Parent Category ID" to remain in "New Category" sheet and always reference "Master Category" sheet or bring over the values?
£15 GBP v 1 dni
5,0 (14 recenze)
5,1
5,1
Avatar uživatele
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel Proposed Milestones £20 GBP - 100% milestone and release upon completion
£20 GBP v 1 dni
4,8 (70 recenze)
5,4
5,4
Avatar uživatele
With my drive for excellence and more than 10 years experience working with Microsoft, i can do the best and most accurate job for you immediately. Thanks Relevant Skills and Experience I am reliable, focused Proposed Milestones £13 GBP - Great Job Guaranteed
£13 GBP v 0 dni
4,8 (35 recenze)
4,6
4,6
Avatar uživatele
Hi My name is Dan. I am an expert in excel and I can do this formulafor you right away. Please message me and share the actual files so that we can proceed further. Thanks! Regards, Dan
£19 GBP v 1 dni
5,0 (11 recenze)
4,6
4,6
Avatar uživatele
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
£20 GBP v 1 dni
5,0 (18 recenze)
4,3
4,3
Avatar uživatele
Hey, I'm interested in your project. Please send me a message so that we can discuss more. Relevant Skills and Experience excel Proposed Milestones £18 GBP - on completion Stay tuned, I'm still working on this proposal.
£18 GBP v 1 dni
5,0 (13 recenze)
3,9
3,9
Avatar uživatele
Hello Sir, I went through the description Kindly send me the document and will complete it today This can be done by index and match functions Please review my past jobs and will do perfect job for you cost can be negotiated I am looking forward to hearing from you my key values to the clients are Delivery on time, Competitive price and perfect quality Thanks regards Thushara
£19 GBP v 1 dni
4,9 (18 recenze)
4,0
4,0
Avatar uživatele
can you share the file? Relevant Skills and Experience .. Proposed Milestones £18 GBP - ..
£18 GBP v 1 dni
5,0 (15 recenze)
3,6
3,6
Avatar uživatele
i can do this, Please review my profile and inbox me thanks Relevant Skills and Experience Excel Proposed Milestones £11 GBP - upon completion
£11 GBP v 1 dni
4,8 (11 recenze)
3,3
3,3
Avatar uživatele
expert is here sir
£13 GBP v 1 dni
5,0 (6 recenze)
3,0
3,0
Avatar uživatele
Being an expert excel user which enables to undertake this job effectively .waiting for your response to proceed further Relevant Skills and Experience Microsoft excel user Proposed Milestones £18 GBP - As per requirement
£18 GBP v 1 dni
5,0 (4 recenze)
2,9
2,9
Avatar uživatele
I have a lot of VBA code tested and ready to use in this project. I can work fast and full-time for you.
£20 GBP v 2 dnech
5,0 (3 recenze)
3,1
3,1
Avatar uživatele
So you want to add "categoryid" and "parentid" to the new spreadsheet to match the Printer Title. Sounds straightforward.
£13 GBP v 3 dnech
4,6 (5 recenze)
2,7
2,7

O klientovi

Pochází z UNITED KINGDOM
UK, United Kingdom
5,0
52
Ověřená platební metoda
Členem od říj 12, 2011

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.