I'm building a tracker that's looking at recurring expenses from four different locations. Because I added a table to excel, it won't let me share the book, so I want this one table or range to populate/pull the information as its updated on the other four products. This table needs to expand as these four tables expand, this way there's no overlap of information. Or missing information. Each excel product for each flight will be labeled with it's flight designator as well as its tab (ex. ATH, not sheet 1).
The table will look something like this. (Sorry if this is crude, the tables here won't load on this computer) :/
A................B.................C.......................D..........................E.............................F...........................G
FLIGHT........ITEM...........SOURCE............COST PER........PROJECTED COST
ATH............books..........web link................$$$.....................$$$$
ATH...........pencils.............wbl...................$$$.....................$$$$
ATH...........................................................................................
DOQ...........paper.............xxxx..................$$........................$$$
DOQ...........stuff................xxx...................$$......................$$$$
MXZ..........More stuff...........xx....................................................
MXZ..........................................................................................
OSS..........................................................................................
Sheet 1(main product)
___________________________________________________________________________________________________________
Again, sorry if this is a crude representation of what I need help with. I just want this one product to report or pull from the other products (saved elsewhere). Also, the products this file is pulling from will all look just like this to avoid conflict of information. I think that each of the four products will have their own tables/ranges, this way they can filter accordingly. These ranges will probably only be 20 rows, at most. The main product will then have no need to filter anything. Can you help?
Sorry if I'm not the best at explaining, I'm still learning how to work this massive, and extremely useful product.
Thank you!
-Mike
The table will look something like this. (Sorry if this is crude, the tables here won't load on this computer) :/
A................B.................C.......................D..........................E.............................F...........................G
FLIGHT........ITEM...........SOURCE............COST PER........PROJECTED COST
ATH............books..........web link................$$$.....................$$$$
ATH...........pencils.............wbl...................$$$.....................$$$$
ATH...........................................................................................
DOQ...........paper.............xxxx..................$$........................$$$
DOQ...........stuff................xxx...................$$......................$$$$
MXZ..........More stuff...........xx....................................................
MXZ..........................................................................................
OSS..........................................................................................
Sheet 1(main product)
___________________________________________________________________________________________________________
Again, sorry if this is a crude representation of what I need help with. I just want this one product to report or pull from the other products (saved elsewhere). Also, the products this file is pulling from will all look just like this to avoid conflict of information. I think that each of the four products will have their own tables/ranges, this way they can filter accordingly. These ranges will probably only be 20 rows, at most. The main product will then have no need to filter anything. Can you help?
Sorry if I'm not the best at explaining, I'm still learning how to work this massive, and extremely useful product.
Thank you!
-Mike
Last edited:
