Lookup repeated values, extract info from that row and sum other values associated

This is the second part of my whole problem. First part of the problem and the a demo file i have posted here


In Colum B where i have ticket #s and some of the tickets are repeated every month . I need to find a way to sort all the repeated tickets (within one month jan/feb etc based on column A) and output into another tab on that spreadsheet. That way i have all the unique tickets from any given month (not the year).



Thanks

@ Tigeavatar

So far i have done the following:
- Created a new tab called 'Filter Data'
- Changed 'Sheet 1' to 'Raw Data' and 'Sheet 2' to 'Filter Data'
- Open the tab 'Filter data ' and tried to run the macro BUT i get a run time error 9 highlighting 'raw data'

Need your expertise thanks

tms12,

Can you post the workbook please, so I can better help you?

~tigeravatar

tms12,

The reason you were getting an error regarding the sheetname, was because the sheet Raw Data has a space at the end of it:
-Instead of "Raw Data" it was "Raw Data "

Also, many of the ParterObj numbers were numbers stored as text. I highlighted all of column B in the "Raw Data " sheet and ran the following simple macro to convert them to numbers:

Please Login or Register  to view this content.

Lastly, because the sheetnames had spaces in them, I needed to update a section of the code to surround sheet names in single quotes in order to retrieve the data you were looking for:

Please Login or Register  to view this content.

After that, running the macro worked fine. I have attached a modified copy of your workbook. Here is the updated macro with your sheetnames and the updated section of code:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar