Project on merging a number of sheets on excel

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.



Habilidades: Processamento de dados, Excel

Veja mais: how to pull data from multiple worksheets in excel, consolidate worksheets wizard, how to merge two excel sheets based on one column, merge excel sheets online, merge multiple excel files into one sheet vba, merge excel workbooks, how do you merge two excel spreadsheets together?, combine multiple excel sheets into one sheet

Acerca do Empregador:
( 0 comentários ) Balham, United Kingdom

ID do Projeto: #18749518

Concedido a:


"""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 m Mais

£25 GBP / hora
(196 Comentários)

12 freelancers estão ofertando em média £13/hora para esse trabalho


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 / hora
(302 Comentários)

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 / hora
(69 Comentários)

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

£13 GBP / hora
(69 Comentários)

Dear Briana I have read the requirements and completely understand the project. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will Mais

£10 GBP / hora
(63 Comentários)

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

£11 GBP / hora
(33 Comentários)

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 Proc Mais

£10 GBP / hora
(9 Comentários)

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 / hora
(6 Comentários)

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 Mais

£13 GBP / hora
(3 Comentários)

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 w Mais

£10 GBP / hora
(1 Comentário)

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 / hora
(0 Comentários)

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 Mais

£11 GBP / hora
(0 Comentários)