- Mar 22, 2006
- 1,046
- 0
- 76
Mods: First things first. If this is in the wrong forum, please move it. I'm just not sure where this should go.
Now to my problem. I'm trying to create a spreadsheet or database or whatever is the best option to automate or at least simplify the following process for work.
Each day I have to look up several items and get a list of how many were ordered by each store, and then add together how many of each they ordered and enter separate information elsewhere depending on how many they ordered total. For example, let's say store 635 orders 2 bins of fiction books, 1 bin of non-fiction books, and 1 bin of assorted toys. I have to add all of these items up and when the total is 3 or more, I have to enter the information elsewhere, but if it's 2 or less I can ignore the store. Here's where my issue comes in. I have to do this for 4 different warehouses, for anywhere from 100-200 stores in each warehouse daily, in a 30-minute window and I have no easy way to add the different stores together automatically. On top of that, not every store will be listed every day. If they didn't order any of a particular item, they don't show up on the list so it will fluctuate from day to day.
What I want is a way to copy and paste the store list and quantity ordered for each item and then automatically add the items together and create a new list with the total number of items per store. Once its built, it needs to be super-simple for the technologically challeneged because I won't be the only one using it. The list that I get from our system is formatted in 3 columns, something like this:
Store Ord Qty | Store Ord Qty | Store Ord Qty
There is no export function, so it will require me to copy and paste the list.
What do I use to do this? I've tried an Excel spreadsheet but I'm stuck. I don't know Access at all but I'm definitely willing to learn if that's my best option, or is there something else I can use that would be better?
I really appreciate any help anybody can give me.
Now to my problem. I'm trying to create a spreadsheet or database or whatever is the best option to automate or at least simplify the following process for work.
Each day I have to look up several items and get a list of how many were ordered by each store, and then add together how many of each they ordered and enter separate information elsewhere depending on how many they ordered total. For example, let's say store 635 orders 2 bins of fiction books, 1 bin of non-fiction books, and 1 bin of assorted toys. I have to add all of these items up and when the total is 3 or more, I have to enter the information elsewhere, but if it's 2 or less I can ignore the store. Here's where my issue comes in. I have to do this for 4 different warehouses, for anywhere from 100-200 stores in each warehouse daily, in a 30-minute window and I have no easy way to add the different stores together automatically. On top of that, not every store will be listed every day. If they didn't order any of a particular item, they don't show up on the list so it will fluctuate from day to day.
What I want is a way to copy and paste the store list and quantity ordered for each item and then automatically add the items together and create a new list with the total number of items per store. Once its built, it needs to be super-simple for the technologically challeneged because I won't be the only one using it. The list that I get from our system is formatted in 3 columns, something like this:
Store Ord Qty | Store Ord Qty | Store Ord Qty
There is no export function, so it will require me to copy and paste the list.
What do I use to do this? I've tried an Excel spreadsheet but I'm stuck. I don't know Access at all but I'm definitely willing to learn if that's my best option, or is there something else I can use that would be better?
I really appreciate any help anybody can give me.
Facebook
Twitter