appending tables

**ronster** · 01-10-2011, 08:08 PM

How would I append two tables side by side on the same sheet into a (single) third master table? The tables each have three exactly similar columns: quantity, length, and width. Very simply, I just need to join these into a long list. Cut and paste will not work because the tables are dynamic and need to be added to in the worksheet.

**JBeaucaire** · 01-10-2011, 09:16 PM

Post your sample workbook showing these two dynamic tables and an exact mockup of exactly where/how the new table should look. We'll see what we can suggest...

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

**ronster** · 01-11-2011, 05:19 AM

posting attached sample...I would like to be able to combine both table1 and 2 into a single master table. Pivot table, and consolidate command won't work for me because they try to sum the numbers which is not what I need. I just need the list merged.

**JBeaucaire** · 01-11-2011, 07:19 PM

This is a sheet event macro, found in the sheet module and is active at all times. It recreates Table 3 every time you make any change in Tables 1 & 2.

Please Login or Register  to view this content.

**ronster** · 01-15-2011, 09:52 AM

Thank you! That worked very well. I appreciate the help.

**JBeaucaire** · 01-15-2011, 01:36 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

**ronster** · 01-20-2011, 10:17 PM

So far the code you provided me with worked perfectly, much thanks. And I have been learning alot by studying it. What would I need to change in the code though in order for it to copy content(data) from cells and not formulas. As of now, if table 1 or 2 cells are referencing their data from another locaction, then the code copys the formula and ends up displaying zeros.