How to Merge 3 tables from 3 different sheets.

Jaredbuoy

New Member
Joined
Oct 25, 2022
Messages
9
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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!
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top