Loop through Worksheets find Value & Paste in another Worksheet, SUM values from Column

PROBLEM SOLVE LOOK LAST POST

Hi I have 12 Workboots (each for every month) name Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
These workbookts contains something like the following

Name	Days of Vacation	Something Else#1	Something Else#2
Mary	5	etc	etc
George	3
John	12	etc	etc
Gary	13	etc	etc

I want something to loop through the months and copy all rows for mary in a summary sheet and sum the Days of Vacation from Column B in the lastrow+1

Of course I dind't come here empty handed, but I can't advance any further.
Could you help me?

Please Note that The first Workbook has some data, the 2nd Workbook is the Jan and the 13 Workbook is the Dec, the 14t is the Summary Workbook

Please Login or Register  to view this content.

Do you have 12 workbooks or 12 worksheets in a workbook? Please understand that there is a significant difference.

Originally Posted by Myth0S

Of course I dind't come here empty handed, but I can't advance any further.

Did you write this code or is this another "I found it on the forum and it worked for someone else so i assumed it would work for me but I have no idea what it does" kind of things.

No offense meant, I am just trying to understand.

I think you missed a question in my first post.

Originally Posted by stnkynts

Do you have 12 workbooks or 12 worksheets in a workbook?

Secondly, assuming you meant worksheets, you said you have 12 of them. One for each month. But then you mentioned a summary sheet. Wouldn't that be 13 sheets not 12?

Additionally, you only mention Mary. You don't mention how you want to choose Mary. Do we always apply the code to Mary? What about George, John, and Gary? We don't want them to be left out. They will end up hating Mary if we do. There will be office gossip about how she slept with this person or that person. People will give her dirty stares. I already feel bad for Mary. So, how should we tell it to pick the other people? Do you want an input box? Should we cycle through everyone?

A little clarification on your end might prevent all the horrible verbal atrocities that are about to befall Mary.

Please Login or Register  to view this content.

The above VBA code works fast and does the job needed.