Đã 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 thêm: 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ê:
( 48 nhận xét ) UK, United Kingdom

Mã Dự Án: #16104916

Đã 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
(333 Đánh Giá)
6.6

44 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
(642 Đánh Giá)
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
(367 Đánh Giá)
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 Giá)
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
(151 Đánh Giá)
6.4
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
(63 Đánh Giá)
5.6
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
(66 Đánh Giá)
5.3
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
(107 Đánh Giá)
5.4
£13 GBP trong 1 ngày
(43 Đánh Giá)
5.6
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
(8 Đánh Giá)
4.8
awaisjahangir25

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

£18 GBP trong 1 ngày
(24 Đánh Giá)
4.6
£18 GBP trong 1 ngày
(14 Đánh Giá)
4.7
£20 GBP trong 2 ngày
(61 Đánh Giá)
4.3
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
(10 Đánh Giá)
4.3
dayakmlt

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

£18 GBP trong 1 ngày
(14 Đánh Giá)
3.6
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
(8 Đánh Giá)
3.1
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
(11 Đánh Giá)
3.3
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
(6 Đánh Giá)
3.1
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
(5 Đánh Giá)
2.7
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
(2 Đánh Giá)
2.8
haleem0786

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 trong 1 ngày
(5 Đánh Giá)
2.4