TransferSpreed Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble figuring out how to transer ALL sheets in a single
workboog into an access table at the same time.

I've tried using a 3d range in the argument =ACNI04:SNFP01!B55:G160

But it doesn't seem to like it. If I leave range blank, it only brings in
the first sheet. How do I import every sheet and append them regardless of
their number and name.

Thanks!
 
Can you create a named range that contains multiple sheets? If so, you could
try importing the named range. Otherwise, I don't believe it's possible.
 
You must log in or register to reply here.

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

Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Macro to copy value in field and insert it into filter 2
Can Vba workout if a selection is part of a group? 0
Excel vba code to match duplicates 4
Count the columns from one sheet and paste it in another sheet 0
Copy Array to Array, how to and should I? 13
Optional argument as Variant not acting like number 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Back
Top