Inserting a table with VBA

B

bg

Good Afternoon,

I am looking for advice on adding VBA to a my Excel workbook to copy a table
and move it into a Summary tab that has other data in already. It's not that
straight forward tho'

It needs to look at which tab to go to first. All of the tabs end with the
name Exercise. for example Tool Exercise, Written Exercise, etc..

They choose this option in Tab 1 Cell A12 and it goes to the desired tab and
creates a table in I7:N20 this is what needs copied into the Summary tab
below the other data? Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
VBA to copy from one workbook into another 0
Mail Merge file containing a Word Table 0
Indirect? or Match? ?? 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
On exit? 3
Compare 2 columns, return a 3rd macro 6
Need Help with a VBA subroutine 0

Top