Excel query and link named range
I have book1 that has a query that brings down a list from access (name=
Project). I need to use this list in a drop down box (validation). I also
need to update the list periodically.
The problem is that my users are opening the spreadsheet as a template and
may need updates while using it. They do not have Access so they can't do
So, I wanted to create book1 with the list & query. Then have the template
(book2) reference the list in book1.
1) doing a copy/paste/named range macro but that just seems like a workaround
2) creating a named range in book2 that references book1 but it only works
when book1 is open.
|All times are GMT +1. The time now is 10:50 PM.|
Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.