Consolidating Multiple Tables from Multiple Worksheets onto one Worksheet????

**JB20** · 10-01-2015, 12:36 PM

Hi Everyone,
I am currently stumped I have been trying to figure out how to capture 14 tables that are on separate worksheets in the same workbook and regenerate all 14 tables into 1 large table. Is this possibe?

My Ultimate goal is that I would really like to be able to generate one table that gathers all the information from these 14 tables. Either by use of an ActiveX text box, drop down list or the basic filter the the table uses.

Thank you all for any help

**stnkynts** · 10-01-2015, 12:55 PM

There is not enough information to answer your question. Submit an example workbook which clearly demonstrates what you are trying to accomplish. Make sure to include a before and after example.

Consolidating Multiple Tables from Multiple Worksheets onto one Worksheet????

LinkBack

Thread Tools

Rate This Thread

Display

Consolidating Multiple Tables from Multiple Worksheets onto one Worksheet????

Re: Consolidating Multiple Tables from Multiple Worksheets onto one Worksheet????

Thread Information

Users Browsing this Thread

Similar Threads

Consolidating multiple workbooks and worksheets

[SOLVED] Cleaning and Consolidating Multiple Worksheets

[SOLVED] Consolidating data from multiple worksheets

Consolidating data from multiple worksheets

Consolidating multiple worksheets into one

Consolidating multiple worksheets

Consolidating data from multiple worksheets

[SOLVED] Consolidating multiple worksheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions