Snowshoeken
Active Member
- Joined
- Aug 8, 2002
- Messages
- 306
I am trying to update tables using saved queries and have them return data in the same cells where the tables reside. Idealy I would like to have a button that would run the saved queries and update the tables. Or maybe there is another way to do this by possibly using the "refresh" data function? Here is an example of the tables that I am working with.
Regards,
Snowshoeken
test_example.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | NPA | NXX | ||||||||
2 | 123 | 951 | 123 | 456 | ||||||
3 | 123 | 952 | NPA | NXX | NPA | NXX | ||||
4 | 123 | 953 | 123 | 851 | 456 | 451 | ||||
5 | 123 | 851 | 123 | 852 | 456 | 452 | ||||
6 | 123 | 852 | 123 | 951 | 456 | 453 | ||||
7 | 456 | 451 | 123 | 952 | 456 | 454 | ||||
8 | 456 | 452 | 123 | 953 | ||||||
9 | 456 | 453 | ||||||||
10 | 456 | 454 | ||||||||
11 | ||||||||||
Sheet1 |
Regards,
Snowshoeken