Excel Macro to copy data from multiple sheets into 1 summary sheet

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I have an excel file with multiple sheets all with the same table schema. I need a macro made that will search each sheet and copy over any records from that sheet to a summary sheet. I have already made a macro that is sort of working, except it is copying over the table header which I do not want to happen, it is also copying over some blank fields which i also do not want to happen. Finally i would like the macro to run when the sheet is opened.

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #16455104

About the project

15 proposals Remote project Active 6 years ago

Awarded to:

cgullapalli

Hi, I am good at Excel and vba. Looking forward to work on the project and discuss in the chat. I have experience in transferring the data from worksheets to summary sheet using macro. -Chandra

$35 USD in 0 days
(820 Reviews)
7.9

15 freelancers are bidding on average $108 for this job

jaylancer43

Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-stor More

$150 USD in 2 days
(669 Reviews)
8.4
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. IF you are interested, please message me and i believe i can help you in matter of minutes. This is pretty simple but i would like for More

$35 USD in 0 days
(437 Reviews)
6.9
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. I am a Business More

$100 USD in 3 days
(196 Reviews)
6.8
ANimesh996

Hello sir, I am the perfect person to help you in this project because I have experience with this kind Data Entry work. Please ping me so I can show you some example of my work. My Skills and Experience range from More

$155 USD in 3 days
(13 Reviews)
2.9
PakMaster

will do it for you sir please give me a chance i do same work for 2 clients please give me a chance surely you enjoy my services...................

$30 USD in 3 days
(2 Reviews)
2.2
gladiali

Hi there! I've made similar macros before, in my working place. I can do it again for you, and you will be 100% satisfied. Let me know if you want to know more about me. Looking forward to hearing from you. More

$100 USD in 3 days
(1 Review)
1.6
omor3842

Hi, I have got your Job posting about like Data Entry Work. I think that I will do well in this sector. Because I know that data entry work perfect for hard workers and I believe on hard work. Anybody can not be compl More

$155 USD in 3 days
(0 Reviews)
0.0
saadabouchadi

I've worked for 2 years as a financial auditor/data analyst to be an experienced excel user. I can guarantee quality work in a short timeframe

$55 USD in 1 day
(0 Reviews)
0.0
rakeeb369

I am able to do tgis project

$155 USD in 3 days
(0 Reviews)
0.0
faheemkerio

I am hard working student if you give me this opportunity I will prove to you that you did the right decision to choose me thanks

$35 USD in 4 days
(0 Reviews)
0.0