Hi. Is there any easy way to load a table from the same query in multiple different sheets? (without just duplicating the query).
Hi. Is there any easy way to load a table from the same query in multiple different sheets? (without just duplicating the query).
Why not just duplicate the worksheets?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oh, well that's certainly an option, but then it duplicates the query as well + I have already made the worksheets where I want to use table. Currently I am pointing to one main table using dynamic arrays on each worksheet, but I realised that having a table on each page would work better for keeping things fully dynamic for my purposes (I could do it with dynamic arrays, but it's going to be more complicated for some of the things I am doing). Worst case scenario, I will just duplicate the queries if need be (just had hope there would be some way to use the same query multiple times without duplication.
Not that I can think of ...
Ah ok. Well in that case, I guess I will be duplicating the queries. Thanks regardless.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks