I created 5 tables from 1 main table, so that I could reference them easyer. The main table has 10,00+ items with no category for a filter. I added 5 and used Y/N to filter. Some items will appear in multiple lists. I used Microsoft Query and things worked but the tables wouldn’t update, then I found Power Query and the updating worked, but dropdown to select the Tables stopped working.
First table---Whse:Product:Description:Onhand:Avg Cost:YTD #:LY #:Last Sale: Sugg. Retail: Paving:Iowa:Nebraska:Non-DOT:Rebar:
InventoryTable--- Product:Description:Avg Cost: Sugg. Retail: Paving:Iowa:Nebraska:Non-DOT:Rebar:
PavingTable--- Product:Description:Avg Cost: Sugg. Retail: Paving
IowaTable--- Product:Description:Avg Cost: Sugg. Retail: Iowa:
NebraskaTable--- Product:Description:Avg Cost: Sugg. Retail: Nebraska:
NonDotTable--- Product:Description:Avg Cost: Sugg. Retail: Non-DOT:
RebarTable--- Product:Description:Avg Cost: Sugg. Retail: Rebar:
=INDIRECT("PavingTable[Description]") returns table info
=INDIRECT("RebarTable[Description]") returns table info
=INDIRECT("NonDOTTable[Description]") returns #VALUE!
=INDIRECT("NebraskaTable[Description]") returns #VALUE!
=INDIRECT("IowaTable[Description]") returns #VALUE!
=INDIRECT("InventoryTable[Description]") returns table info
Capture.JPG
I am trying to get all the code on one line so i can copy the formating to the row below and just change the selected item
If you have any suggestions I am open to ideas!!
Bookmarks