StockKeeper
New Member
- Joined
- Nov 29, 2016
- Messages
- 1
Hello!
My name is Robin, and I work at an re-seller of electronical items in Norway. I have an idea that I would like to make, but even though I have used Excel for tasks before, I kind of don't know where to start. I'm just going to write what I want the sheet to do, and if someone could just give me a hint of what I need to read up upon, it would be much appreciated!
I work in the Aftersales department.
Everyday, we receive pallets with items from our major distributor. The same day the trailer with items arrive, we also get a packing-note. For every pallet we take apart, we need to find every item, and 'check' them of in the list. This is to ensure that we actually get what we are ordering, and to see what we have to report as missing.
This process it extremely time consuming, and is something that I would like to speed up. So here is my idea;
The picture above is what the packing note looks like.
Break down:
Red circle - This is the number(name) of the box, or pallet the items is in.
Green circle - This is the name of the item that should be in the pallet or box.
Blue circle - This is the amount of items like this we are waiting to receive.
What I would like to make in Excel, is a program that automatically takes the PDF document (pre-uploaded to a certain folder by user), breaks the information into separate fields that is pre-configured by me. For example like this:
And when all the items on the pallets have been checked, the Excel document should automatically generate a new printable document with a complete list of everything that is either Missing or Too Much. Like this:
Now here comes the real tricky part...
Sorry if I am expressing myself badly, English is my second language...
Lets say there is a barcode named "1000000000XXXXXABC" on a BOX. I take the barcode scanner, and scan it. I need the document to automatically jump to that BOX on the list, and start checking the items. When all items in the box is emptied, the user can press enter, and you are ready to scan a new BOX or Pallet.
The IT department will help me connect the document to our systems, so that the document knows what barcode belongs to which item.
Questions remaining guys:
- How can I make Excel get data from PDF into a document like the one I've made?
- How can I make the document work with a barcode scanner, and behave the way I want it to?
Again guys, any help, or links to information - would be very appreciated!
My name is Robin, and I work at an re-seller of electronical items in Norway. I have an idea that I would like to make, but even though I have used Excel for tasks before, I kind of don't know where to start. I'm just going to write what I want the sheet to do, and if someone could just give me a hint of what I need to read up upon, it would be much appreciated!
I work in the Aftersales department.
Everyday, we receive pallets with items from our major distributor. The same day the trailer with items arrive, we also get a packing-note. For every pallet we take apart, we need to find every item, and 'check' them of in the list. This is to ensure that we actually get what we are ordering, and to see what we have to report as missing.
This process it extremely time consuming, and is something that I would like to speed up. So here is my idea;
The picture above is what the packing note looks like.
Break down:
Red circle - This is the number(name) of the box, or pallet the items is in.
Green circle - This is the name of the item that should be in the pallet or box.
Blue circle - This is the amount of items like this we are waiting to receive.
What I would like to make in Excel, is a program that automatically takes the PDF document (pre-uploaded to a certain folder by user), breaks the information into separate fields that is pre-configured by me. For example like this:
And when all the items on the pallets have been checked, the Excel document should automatically generate a new printable document with a complete list of everything that is either Missing or Too Much. Like this:
Now here comes the real tricky part...
Sorry if I am expressing myself badly, English is my second language...
Lets say there is a barcode named "1000000000XXXXXABC" on a BOX. I take the barcode scanner, and scan it. I need the document to automatically jump to that BOX on the list, and start checking the items. When all items in the box is emptied, the user can press enter, and you are ready to scan a new BOX or Pallet.
The IT department will help me connect the document to our systems, so that the document knows what barcode belongs to which item.
Questions remaining guys:
- How can I make Excel get data from PDF into a document like the one I've made?
- How can I make the document work with a barcode scanner, and behave the way I want it to?
Again guys, any help, or links to information - would be very appreciated!
