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
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