Đã hoàn thành

Excel spreadsheet help CATEGORY

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

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic

Xem nhiều hơn: how to create categories in excel 2013, how to create categories in excel 2010, excel category list, how to add categories in excel drop down list, how to make sub categories in excel, how to add categories in excel chart, create a drop-down list of possible input values, how to create categories in excel 2016, need help with excel spreadsheet, overseas excel spreadsheet help needed, help with excel spreadsheet for business, excel online help expert live, capital market excel sheet expert freelancer, excel sheet expert, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel

Về Bên Thuê:
( 51 nhận xét ) UK, United Kingdom

ID dự án: #16104916

Được trao cho:

MimiFL

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 Thêm

£10 GBP trong 0 ngày
(365 Đánh Giá)
6.7

43 freelancer đang chào giá trung bình £17 cho công việc này

cgullapalli

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, Ma Thêm

£20 GBP trong 0 ngày
(672 Nhận xét)
7.7
ponnarasiBabu

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 trong 1 ngày
(376 Nhận xét)
7.3
haresh31dec1982

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 Pro Thêm

£10 GBP trong 1 ngày
(25 Nhận xét)
7.2
avinav606lx

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 dis Thêm

£21 GBP trong 1 ngày
(154 Nhận xét)
6.5
sajibdigital

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 Thêm

£16 GBP trong 1 ngày
(66 Nhận xét)
5.7
£13 GBP trong 1 ngày
(43 Nhận xét)
5.6
£18 GBP trong 1 ngày
(29 Nhận xét)
5.4
arman0464

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, V Thêm

£18 GBP trong 1 ngày
(110 Nhận xét)
5.4
renesontiongson

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% Thêm

£20 GBP trong 1 ngày
(68 Nhận xét)
5.3
awaisjahangir25

Hi, I can work out on your requirement. Kindly text me for further details. Regards

£18 GBP trong 1 ngày
(28 Nhận xét)
5.0
RPaul73

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 Proce Thêm

£15 GBP trong 1 ngày
(11 Nhận xét)
4.9
dank111

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 trong 1 ngày
(11 Nhận xét)
4.6
khudammunir

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, Thêm

£20 GBP trong 1 ngày
(15 Nhận xét)
4.1
£20 GBP trong 2 ngày
(61 Nhận xét)
4.3
supper5guy

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 Propose Thêm

£13 GBP trong 0 ngày
(29 Nhận xét)
4.3
nelumindralal

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 Thêm

£19 GBP trong 1 ngày
(14 Nhận xét)
3.9
dayakmlt

can you share the file? Relevant Skills and Experience .. Proposed Milestones £18 GBP - ..

£18 GBP trong 1 ngày
(14 Nhận xét)
3.6
dataprotech

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 prop Thêm

£18 GBP trong 1 ngày
(10 Nhận xét)
3.7
Ghulamali1656067

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 requir Thêm

£18 GBP trong 1 ngày
(4 Nhận xét)
2.9
Carlosemadrizmor

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 trong 2 ngày
(3 Nhận xét)
3.1