Sort and copy data from custom formatted tables on multiple sheets to one area

[christmaslyric]

I have a custom formatted table that lists products purchased. It has 9 columns. The first column (A) is the vendor name and the other columns define what the product is, the cost, received date and so on....one row per product. This table is the same on all worksheets, same columns, rows, headings, etc. What I would like to do is be able to sort by vendor name and then copy all related information from the vendor on that row to another table from all the worksheets. I would then have a table of each vendor's information of products purchased that has been gathered from all the worksheets and be able to see all the products purchased from each individual vendor in their own tables. I hope I have explained that well.

[oeldere]

I would collect all data on 1 sheet (e.g. with an macro).

After that you can use pivot table for analyzing.

Or you can use a filter for analyzing.

[daffodil11]

I motion to second that.

And here's a macro that can do it:

Please Login or Register  to view this content.