Project on merging a number of sheets on excel

£10-15 GBP / hour

已完成

已发布

大约 5 年前

£10-15 GBP / hour

I have a large spreadsheet with around 20 sheets which need to be merged into a single master sheet. The columns on the sheets are all the same but a reference column would need to be added to show which sheet the data has come from. There is also a column on each sheet which displays the parent company and the brands within the parent company by the amounts the text is indented so I need to find a way to split this up into a parent company and brands column using the indentation. I can't use VBA to do this and have been told to use INDIRECT for this. Would greatly appreciate any help even if its just an example of how to do this for a few sheets and I can replicate it for the rest of the sheets. The deadline for this is tomorrow morning so would need help in the next few hours. Believe this should only take an hour or two. Thanks, Briana

Data Processing

Excel

项目 ID: 18749518

关于此项目

11提案

远程项目

活跃5 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """

£25 GBP 在40天之内

4.9

(254条评论)

7.0

11威客以平均价£13 GBP/小时来参与此工作竞价

@mirniyazuddin92

Hi there, I can merging a number of sheets on excel. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

£10 GBP 在40天之内

4.9

(342条评论)

7.9

@polarjin2017

Hello? How are you? I have good skills in those field. So i can help you i fyou want. hoep to work with you.

£16 GBP 在39天之内

4.8

(94条评论)

6.7

@MohsanEijaz

I am interested in your job. I shall complete it soon. Mohsan

£13 GBP 在40天之内

5.0

(84条评论)

6.3

@khurram1984

Hi. i can do this. i am using excel since 2009 and have good understanding of it. please share your sheets

£11 GBP 在2天之内

4.7

(49条评论)

5.8

@olaideejiwole

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, Data Mining, Data Processing, Excel, Web Scraping, R Programming Language, and Data Entry as well. I’m honest, creative and a unique person to carry out your tasks given to me. Leaving your project on our hand is privileged; we'll make sure that the project is done in a perfect way and do our best until you were satisfied. I would love to discuss this project with you and meet your exact requirements. I am confident I can provide you with top-notch materials that will fit your needs. I'm proud of my work on being professional, of the highest quality and always delivered on time.

£10 GBP 在40天之内

4.9

(18条评论)

5.0

@Mickelson

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some automation and scraping, scientific scripts. I have many experience in google spreadsheet. So I think I can help you in your project. Just let me know if you want start job. Regards. Lian

£13 GBP 在40天之内

4.6

(11条评论)

5.0

@engrranakaleem21

Hello, I have already gone through the details from you. I think it is the best suited for me and you will have got an excellent feedback. I am available from now on. I ensure you i will provide you a better quality work. So please call me an invitation. Regards, Rana k.

£10 GBP 在40天之内

4.8

(25条评论)

4.1

@rubnogueira

Hi Briana. Could you provide me with some samples? I can do it in python with an external script which is fast and simple with indirect. Contact me so we could talk better about it. Thanks

£15 GBP 在2天之内

5.0

(6条评论)

3.6

@thaonguyenuw

Hi! I am very familiar with most of the Excel functions, especially indirect! I'm sure can give you a hand on your project! Looking forward to your response! Thao

£13 GBP 在40天之内

0.0

(0条评论)

0.0

@Nerscontent

Data accuracy can improve the quality of your business. Let me help you to do these tasks accurately. I have experience as a Data Administrator, including data entry, financial data, sell sheets and creative writing. My strong skills are data entry and web research. I take every job seriously and give each job 100%. I am a hard and fast worker. I'm reliable, detail oriented, and self-motivated. I will do my best to finish the job accurately, on time and as cost-effective as possible for you. I am pretty quite flexible and negotiable with respect for working hours.

£11 GBP 在40天之内