VBA code summarizing sheets.

Hello,

I was given some help earlier from this geat forum. Of course I forgot to than whoever it was that helped me and provided me with some code (stressed as I am). If you happen to read this, thanks a bunch and sorry for being such a jerk.

As great as the code was, it gave rise to a little problem. I uses a lookup function over multiple sheets (I understand that much...) but the problem is that when having two or more versions of the same workbook open, it summarizes from all of them. I'm guessing that there just needs to be a couple of words added for the module to just summarize the workbook that it is connected to (the same module appears in the new and the older version). Well here is the code:
____________________________________________

Please Login or Register  to view this content.

____________________________________________
(As I mentioned, this was given to me by somene on this board)

If someone cold help me with this I would be very grateful and even remember to say thanks this time

/ Björn

consultantguy

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

You need to be specific which workbook to summarise. Use ThisWorkbook for the workbook containing the code or ActiveWorkbook for the currently active workbook e.g.

Please Login or Register  to view this content.

mudraker: Sorry for that, I didn't know how to do that.

royUK: Thanks, but it still summarizes from the older version of the workbook...

To be a bit clearer:

I have a sheet for summarizing the hours spent by a list of individuals. These appear in both versions of the workbook (the older and the new). The module posted above is also present in both versions.

As other people are supposed to use the workbook and they may import transfer data from an older version to a new version of the workbook, I need to make it som that it only summarizes from the one sheet.

Could the solution be to put the name of the workbook where it now says "ThisWorkBook"? Or to change the "sheets" in

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

?

I'm just guessing here...