How to Merge 3 tables from 3 different sheets.

[Jaredbuoy]

Hi All,

Every Monday I receive a workbook that has 3 sheets, and each sheet has 1 table. There are only 3 companies that's data is stored on each table

I need to filter each company on each table and then merge the tables for each company so that all 3 tables (on each sheet) for 1 company are showing on 1 table before sending it out.

Is it possible to do this and perhaps also make it so it creates a new workbook for each table.

It would be great if I can use a macro to have this automated as it's the same 3 companies just different data each week.

--

Each sheet can be seen a product each of the companies are selling so we want to place all 3 tables together of each company to see their total sales but also send it to each company.

Thank you very much for the time given

 

[jdellasala]

Two words. Power Query. Learn it and you'll save yourself a LOT of TIME and boring repetition! What you're describing might take an hour to set up, and after that literally a few minutes. Great YouTube playlists for it here and here. You should be able to pick up enough after viewing just a few of the videos.

You can always post here if you run into a road block, but please use XL2BB to post data, and the code formatting tools.

Good luck!