Create a summary from multiple sheets on a master/summary sheet

[detribus]

Hi there!

I'm new to VB programming, and i hoped to find a solution without a macro but i guess i have to use a macro.

I have data on several (5) sheets. Every sheet is per Person and include the Data fields, I want to extract the Data of each sheet into one master sheet.

I attached my file in which i explain what i want to achieve. I tried already for several hours until i stumbled over this forum. I added comment to the field need to be in the summary and marked them red. (only on the first sheet "Arnel")

hope someone can help me figure this out.

kind regard
Chris

[mrjinx007]

Need more explaination. Where is the totoal Cod killed? What data from where needs to go to the last sheet?

[jpr73]

Hi,
May be using pivot table wizard
See sheet PT summary : is that it is what you expect ?
Hope this help
Best regards

[detribus]

Hi,
thanks for the reply.
I found a way to make almost what i want only that it is not really automatically! In the the attachment is my new file with a macro i found in the web and some recorded by my self. what I'm now looking for would be that the last worksheet (Sheet4) gets updated Automatically when i change Data on one of the other Worksheets. I played around also with Access but i understand this less than exel ;-)

The macro is assigned to the textbox on the Total Woorksheet.

My plan was that i can generate a weekly and monthy report about the killed Crown of thorns.

thanks for the help
Chris