Create Arrays from external workbook and add worksheet table data to the arrays

L

Legacy 392984

Guest
I have a workbook that will be my main program. From this workbook I need to do the following in VBA.
1) Reference external workbook (hardcoded location).
2) Create arrays based on the sheet names in this external workbook
3) Populate each array with the table data in each worksheet once the array is created. The tables are named the same as the worksheets.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,099,376
Messages
5,468,248
Members
406,575
Latest member
Joe00

This Week's Hot Topics

Top