Hello, I am Daniel, and I humbly ask for your help.
I usually am able to figure all this kind of stuff on my own, but I hit a roadblock here, kind of complicated.
I work for a company that ships to 4 different big retailers like Walmart, Family Dollar, etc.
I keep all the info in a little excel file where all of the orders and inventories are kept, along with individual warehouse addresses to ship to.
Now, when we are given the ok to ship the orders, we call the trucks. This leaves me with an hour; from the time we call this trucks up to the time they come to pick up the merchandise, to create the BOL's (Bill of Ladings). Sometimes up to 52 BOL's have to be typed in less than an hour. I have a template of the BOL in Excel, but every order needs to go to a different address, with a different PO, a different number of cases, or truck, etc etc.
Right now I scramble a lot in trying to make this BOL's, and often times I make mistakes. But all the correct information, all of it, is already typed into the inventory itself, there is a lot of time wasted just in going back and forth refilling all this info in the BOL template and print.
This is what I need to know: Is there any way to store about 200 macros(each with its own individual shortcuts); or to create a little script that ask the user for input and then auto-fill certain fields from other worksheets so I can, for example, type in the PO number of a certain order and it will fill the number of cases from one worksheet, the address from another worksheet, the date from a different one, etc etc, automatically?
I have tried Macros but it seems that the shortcuts will be less than 60. I need about 200 or so.
Thank you in advance.
Bookmarks