P
phuser
Ok I'll try this differently and hopefully someone will get what Im trying
to do.
Currently I am using a spreadsheet it's called a Want Load Sheet
Guy comes in and puts in the Want Column qty he wants for next week's load
The spreadsheet contains about 50 macro's and is getting way out of hand.
WA is linked to the previous weeks sheet, ADD is (Count - WA), Cout is QOH,
Out is what was loaded last Week and In just calculates the count/Case qty
The guys who use this Spreadsheet use the computer once a week and only
input Qty's in the Want Column, everything else is historical data that they
use to figure out what they might want to order.
I have this WB Split up for 3 different Branches with 25 different sheets.
Access just seems lilke the next step to take, I know how to do the tables &
querys to get the reports to generate but the form so these guys can see
historical data and input what they want has me pondering.
I have consulted warehouse staff and it's mandatory they see all items to
scroll through. KISS
WA ADD V Count OUT IN WANT
QFF SANDWICHES
24/Ham & Cheese (Swiss) Sub 24
24/Pizza Sub 24
SPEC PIZZA SUB 24
18/Super Sub 18
24/Torpedo Sub 24
18/Superloaded 18 20.0 19 10 20.0 1
to do.
Currently I am using a spreadsheet it's called a Want Load Sheet
Guy comes in and puts in the Want Column qty he wants for next week's load
The spreadsheet contains about 50 macro's and is getting way out of hand.
WA is linked to the previous weeks sheet, ADD is (Count - WA), Cout is QOH,
Out is what was loaded last Week and In just calculates the count/Case qty
The guys who use this Spreadsheet use the computer once a week and only
input Qty's in the Want Column, everything else is historical data that they
use to figure out what they might want to order.
I have this WB Split up for 3 different Branches with 25 different sheets.
Access just seems lilke the next step to take, I know how to do the tables &
querys to get the reports to generate but the form so these guys can see
historical data and input what they want has me pondering.
I have consulted warehouse staff and it's mandatory they see all items to
scroll through. KISS
WA ADD V Count OUT IN WANT
QFF SANDWICHES
24/Ham & Cheese (Swiss) Sub 24
24/Pizza Sub 24
SPEC PIZZA SUB 24
18/Super Sub 18
24/Torpedo Sub 24
18/Superloaded 18 20.0 19 10 20.0 1