Consolidation of 960 Excel worksheets (Tabs) into one worksheet (Tab). Single Excel file

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

To consolidate data from 960 worksheets (tabs) into one worksheet (new 'Consolidated data' tab) whilst ignoring/deleting some repeated text and blank rows in the consolidated sheet. Please refer to the detailed requirements stated within worksheet 'Consolidated data' attached here before quoting. Sure there must be some way to automate the requirement to make it easier than manual copy/paste/delete.

Update 1 - An enhanced file has been uploaded to include an Excel Tab which illustrates how the consolidated data should be laid out.

Send me any questions, please.

I'll begin by offering one Excel file but may offer a repeat if it goes well

Excel Visual Basic Microsoft Office

Project ID: #27007799

About the project

64 proposals Remote project Active 3 years ago

Awarded to:

(281 Reviews)
7.7

64 freelancers are bidding on average $31 for this job

pm9887

Hello, I can assist you in best way, I have good experience in many type of jobs. I am good in internet research and spreadsheet task. Would like to do some samples to gain your confidence. Let's initiate chat and disc More

$35 AUD in 7 days
(66 Reviews)
5.6
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 hour

$15 AUD in 1 day
(64 Reviews)
5.5
muradeltaher

Greetings! My Name Is Murad And I’d like to be considered for your position. I Have read Your Instructions and well understood Data will be researched perfectly and all details will be put on a well organized exce More

$30 AUD in 1 day
(70 Reviews)
5.0
mowachira77

Hi there, I have fully understood your work about worksheets consolidation and am interested in working in your project. I am an expert in VBA and excel. In this regard, I will be able to automate the process and deli More

$15 AUD in 1 day
(24 Reviews)
4.2
RiWong88

Dear Sir, I am an experienced senior audit accountant that dabbled in data analyst for years during my career. I am fast and precise with my work and I will manage to complete the task as soon as you need it or even be More

$50 AUD in 2 days
(2 Reviews)
2.4
rameshraja86

Hi Jamie I have gone through your update 1. I am sure I can do without any difficulty... I have fully understood your requirement. it won't take more than 4hours. I have 13years experience in excel and excel VBA. I More

$50 AUD in 1 day
(4 Reviews)
1.6
zubairmbafinance

Hi I have experienced in data entry field Also, I have several good records in this field as I have been working in this field for about 5 long years.I am an expertise on Data entry and excel, also have proficiency in More

$20 AUD in 1 day
(2 Reviews)
0.5
ravichandar224

hi. i read your project. i can done your before the required time. thank you

$18 AUD in 2 days
(0 Reviews)
0.0
shamimrezaudc

Hello sir, my name is Shamim Reza My Service >> PDF to Excel, PDF to Word, Bank statement/Business card/CV to Excel, Hand written to word/Excel, Any kind of Copy Typing

$20 AUD in 7 days
(0 Reviews)
0.0
Abhishekemailing

We have a team of well experince data entree operator who is capable for backande work with accuricy and within given timeline.

$20 AUD in 2 days
(0 Reviews)
0.0
utkarshgupta0510

I have through the attachment in the project details. I understand how to work on this project. Please provide more details in the chat section.

$10 AUD in 2 days
(0 Reviews)
0.0
sunilmathewbs

i am an expert in excel. i have completed a lot of projects in data conversion and data consolidation works. I can assure you 100% timely deliver and accuracy.

$25 AUD in 10 days
(0 Reviews)
0.0
darshanapatel09

Hi sir/mem I read your project and i like to work with you. I like to know more details about project on chat. Thnk you.

$30 AUD in 3 days
(0 Reviews)
0.0
meignanammgm

I am not to pay any amount but interest to work I am not to pay any amount but interest to work I am not to pay any amount but interest to work

$20 AUD in 7 days
(0 Reviews)
0.0
sunilrout37

Hi, I am sunil from India and I have completed my PGDM recently. I have an experience in microsoft excel for 5 years. I can work according to your requirement. I wish that you can make me eligible for this bid so that More

$20 AUD in 7 days
(0 Reviews)
0.0
hch574d7f2fa9e62

Here is Data entry expert. Don,t wait just hire me for your best quality project and project will be completed within your time space.

$20 AUD in 7 days
(0 Reviews)
0.0
istieakahmedbd

Hear Hiring Manager, I have seen the job description carfully and I can ensure you that I can sucessfully complete the project. As I have seen the example that you have attached, so you not need to understand me anymo More

$12 AUD in 5 days
(0 Reviews)
0.0
aanasarbi

Hi there, I understand that your work requires a lot of time and patience. I will be able to complete your entire project in less than 3 days if you offer me the project. I will provide you with the best service and ha More

$20 AUD in 3 days
(0 Reviews)
0.0
iftikars

Hmmmmm

$30 AUD in 2 days
(0 Reviews)
0.0
billahkhalid

Hi, I'm ready to do your job. I have huge experience in this project. If you agree with me, I will do the job only for you. Thanks

$25 AUD in 5 days
(0 Reviews)
0.0