Consolidate, filter and copy data to another worksheet

**Dunagh** · 07-07-2010, 03:08 PM

Hello,

I have some workbooks with customer data. Their names can appear anywhere from three to four times with different monetary amounts per row. I need to add up the amounts per customer, filter out customers under a certain amount, and copy all the customer data, along with totals, to another worksheet. I would like to be able to do this with a function or macro so that it can be applied to different workbooks. My Excel coding skills are very week so hopefully someone here can help. Any help would be appreciated.

Thanks,

Rob

**davesexcel** · 07-07-2010, 09:28 PM

Give this a go...

Please Login or Register  to view this content.

**Paul** · 07-07-2010, 09:52 PM

Just a quick note.. when using

Please Login or Register  to view this content.

Only 'c' is being declared as a Range variable, while 'r' is declared as a Variant. (Usually not a huge deal since memory usage isn't really an issue for modern PC's, just proper variable technique in VBA.)

Please Login or Register  to view this content.

Additional info regarding variables: http://www.cpearson.com/excel/DeclaringVariables.aspx

**Dunagh** · 07-08-2010, 07:39 PM

Thanks for the help. With a little modification I got this code to work as I needed it to:

Please Login or Register  to view this content.

The only thing I have left is to filter out the data where the amount is < 3000. I did this with an advanced filter but was wondering if there was a way to do this in the function.

I am also wondering if this line of code takes into account for duplicate names for different people:

Please Login or Register  to view this content.

i.e. if there are multiple John Smiths at different addresses.

Again, thanks for the help. It is greatly appricated.

Rob

Consolidate, filter and copy data to another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Consolidate, filter and copy data to another worksheet

Re: Consolidate, filter and copy data to another worksheet

Re: Consolidate, filter and copy data to another worksheet

Re: Consolidate, filter and copy data to another worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions