K heres the deal. I work at ups and I load the semis. We have to remember the city/zip codes for each of the trailers. There are 7 belts and 40 something different trailers. I want to be able to type out a table with all the city names - zip codes - slics (UPS CODE) on one sheet, but be able to another sheet set up a building sort guide that changes based on each load. The slic can be my reference from one table to another i just dont understand how to copy the table content from one to another.
Sort like this
Green Belt
Wenatchee (98802)
Pullman (9910)
CDA (8380)
Lewiston (8350)
Red Belt
Kennewick (9930)
Walla Walla (9931)
Missula (5980)
... and so on
[each trailer has anywhere from 12 to 60 cities that go in it]
I want to do be able to have a sheet that is per belt (as a whole on what goes) and have another sheet that has each of the trailers Wenatchee(98802), Pullman(9910)... but only having to physically type out the citys and zips codes once instead of 3 times if a change is made to the main table
anyone get what im trying to do?
Sort like this
Green Belt
Wenatchee (98802)
Pullman (9910)
CDA (8380)
Lewiston (8350)
Red Belt
Kennewick (9930)
Walla Walla (9931)
Missula (5980)
... and so on
[each trailer has anywhere from 12 to 60 cities that go in it]
I want to do be able to have a sheet that is per belt (as a whole on what goes) and have another sheet that has each of the trailers Wenatchee(98802), Pullman(9910)... but only having to physically type out the citys and zips codes once instead of 3 times if a change is made to the main table
anyone get what im trying to do?