automatically add sheets and link them to external workbook named

G

Guest

Hi--

I'd like to have a dynamic workbook which automatically makes worksheets
with the following criteria:

1. Each worksheet created based on all workbooks found in a certain folder
and named after that workbook.

2. Each worksheet is linked to a named range (identical name in all
workbooks) in the workbook it corresponds to and this starts at cell A1.

3. As more workbooks are added or deleted from the reference folder, the
consolidating workbook should add or delete the sheet tabs accordingly.

Does this sound doable to anyone?
 

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

Copy Worksheets To New Workbook 2
copy sheets 2
Macro to copy sheets to another workbook fails after about 45 copi 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Save specific sheets to new workbooks adding tomorrow's date to na 1
Copy Multiple Areas from One Workbook to Another 4
adding footer to all existing sheets in workbook and also to newsheets which is added 1
Adding ws information to cell in new wb & saving with ws name 7

Top