Do some Excel Work - relaetd products columns

£20-250 GBP

완료함

게시됨

약 9년 전

£20-250 GBP

제출할때 지불됩니다

HI there I would like an excel expert to fill in a column on my spreadsheet preferably in an automated way using formulas or macros or something. The task would be to to fill in the "related products column" on this spreadsheet as it too slow to do this manually. details: I have a large product spreadsheet (8000 products+) in excel that i use on my website. in this spreadsheet you would need to understand and use 3 columns Category (already completed) Product sku (already completed) Related products (need help completing this) so i need some help with 1 of the columns only : Related products. (column AD) The products are listed into different categories (1500 categories) i.e. Column "A" in our spreadsheet determines the category the product is listed in i.e. - if we have a number 1 in column A - its a product in the red car category , if its is a number 2 in column A it would be blue cars category, number 3 would be yellow cars There are 10 "red cars" listed in the spreadsheet so all have number one listed column A in the category field Each product or red car has a unique product sku listed in Column F i.e 1045 There is a column in the excel spreadsheet - column AD - called "related products" where we can also link to related products for that product I would like an excel expert to find me an automated way using formulas or macros or something to fill in the "related products column" on this spreadsheet as it too slow to do this manually. i.e IF column A = 1/ Red cars- then column AD should contain all the products SKUs - Column F - that are linked to the category Red cars i.e. all the red cars products skus columns F - should be in column - AD The key field is the category field. This is what links the products. Ive attached some images that may explain this better and an example spreadsheet for one product that i did manually. each product sku must be seperated in column AD by a | character i.e 5367|5368|5369|5370|5371|6979|6980|6981|6982|6983|7309|7348

Data Entry

Data Processing

Excel

프로젝트 ID: 7187094

프로젝트 정보

20 제안서

원격근무 프로젝트

활동 중 9년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can deliver within 1 day.

£37 GBP 6일에

4.9

(191 건의 리뷰)

7.2

20 이 프로젝트에 프리랜서들의 평균 입찰은 £86 GBP입니다.

@Ibrahim185

Hi, I have read your project description . i am highly interested to do this task . Let's discuss and start right now. Awaiting for your positive reply,Hope we will work together for this project. thanks.

£250 GBP 5일에

4.9

(864 건의 리뷰)

8.0

@zExcel

Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions

£100 GBP 1일에

4.9

(255 건의 리뷰)

7.6

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

£44 GBP 1일에

5.0

(221 건의 리뷰)

6.9

@ferozstk

Hello, Thank you very much for this Excel Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can complete this Excel project on time and within your budget. I have worked on similar Excel projects, and I am confident I can exceed your expectations. Regards by Feroz Ahmed See My Feedback: www.freelancer.com/u/ferozstk.html

£48 GBP 1일에

4.9

(94 건의 리뷰)

6.6

@raghav1101

Hi, I would love to work on this project. i have 8 years of experience in Microsoft Excel and i have experience working on bulk upload csv files like this one. I have understood the requirement very well. Please contact with further details if interested. Regards, Raghav Bansal

£54 GBP 2일에

4.9

(99 건의 리뷰)

6.6

@Anamika97

Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day, Anamika

£47 GBP 1일에

4.8

(243 건의 리뷰)

6.6

@richkumar

Hello, I have experience in excel. Please check my portfolio. I am ready to start Now. Please review my bid. Thanks. Rich

£38 GBP 3일에

5.0

(104 건의 리뷰)

6.1

@masud0012

A proposal has not yet been provided

£150 GBP 3일에

4.9

(151 건의 리뷰)

6.2

@rumarahman

Hi, I wants to work on your project and is confident on completion within short time working with my team of 6 PPLS. Thank you. Best Regards, Ruma

£150 GBP 3일에

5.0

(42 건의 리뷰)

5.2

@joseluiselp

Hello i can make you a little script for you, this script its going to take your excel file and create a new one with all the column full. Also i notice that your column relatedProducts its wrong because the products are related to theirselves. If you are interested let me know, also you can take a look at my feedbacks. Regards Jose Luis Mendoza.

£44 GBP 1일에

5.0

(3 건의 리뷰)

4.5

@prabakarm23

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M

£55 GBP 3일에

5.0

(50 건의 리뷰)

4.7

@Sandiyaseo

I will fulfill all your requirement If you will choose me the winner then your Expectation fulfilled our team..!! Don't worry I am serious and experienced bidder Please make us winner or you have any questions feel free to ask. We are here for any assistance. I have 2+ year experienced guys teams. I am Ready to start your work as soon as possible...please accept my bid..and give me one chance Best Regards :) - Sandiyaseo

£30 GBP 10일에

4.8

(5 건의 리뷰)

2.9

@Mizanur32

hello sir .. i can do this work ... i have good knowledge of web researching and excel .. so i will be the best candidate for this job .. i will do it in minimum budget and faster than others . .. looking for ur msg thank you

£166 GBP 3일에

4.8

(5 건의 리뷰)

2.2

@palonageoffrey

.Very skilled when it comes to excel worksheets, data entry. Am fast, accurate and very dedicated .

£50 GBP 2일에

5.0

(1 건의 리뷰)

0.5

@mahabubarbd

Hello, Thank you very much for this data entry Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can complete this data entry project on time and within your budget. I have worked on similar data entry projects, and I am confident I can exceed your expectations.

£20 GBP 1일에

0.0

(0 건의 리뷰)

0.0

@klimzpp

Hello! Can do this task for you very quickly. It's not so difficult. Will write a program, that will execute all this work you need. I have wide experience in writing utilities on PHP/C++/C# (including client-servers scripts, web scraping, work with Word/Excel documents, create parsers for extract inrormation, grabbers, and so on). Almost always online, waiting for your answer Thank you.

£84 GBP 3일에