software

The county I work for uses a network and MS OUTLOOK (for emailing). Once a
month, each outlying EMS station fills out a supply reorder, saves it, signs
onto the network and attaches the workbook to the email and sends it to the
supply officer.

I am trying to figure out the best way to set up an inventory control and
have the master inventory quot;filequot; look at each workbook that is downloaded and
saved (on the supply officer's end) and adjust all the inventory.

From my little bit of programming knowledge with excel, I have some ideas
but was wondering if anybody might be able to throw some other ideas my way.

Basically, my idea consist of having a MASTER inventory control spreadsheet
for the supply officer. Each station (7 in all) will have a workbook with 12
worksheets predefined with the reorder setup. Unless someone monkeys with
worksheet names, etc., the MASTER spreadsheet would look at each workbook and
find the correct supply order and pull the numbers and adjust the totals.

Any ideas are appreciated on this.

Thanks,
Les

quot;WLMPilotquot; gt; wrote in message
...
gt; The county I work for uses a network and MS OUTLOOK (for emailing). Once
gt; a
gt; month, each outlying EMS station fills out a supply reorder, saves it,
gt; signs
gt; onto the network and attaches the workbook to the email and sends it to
gt; the
gt; supply officer.
gt;
gt; I am trying to figure out the best way to set up an inventory control and
gt; have the master inventory quot;filequot; look at each workbook that is downloaded
gt; and
gt; saved (on the supply officer's end) and adjust all the inventory.
gt;
gt; From my little bit of programming knowledge with excel, I have some ideas
gt; but was wondering if anybody might be able to throw some other ideas my
gt; way.
gt;
gt; Basically, my idea consist of having a MASTER inventory control
gt; spreadsheet
gt; for the supply officer. Each station (7 in all) will have a workbook with
gt; 12
gt; worksheets predefined with the reorder setup. Unless someone monkeys with
gt; worksheet names, etc., the MASTER spreadsheet would look at each workbook
gt; and
gt; find the correct supply order and pull the numbers and adjust the totals.
gt;
gt; Any ideas are appreciated on this.
gt;
gt; Thanks,
gt; LesAs much as I love Excel, you'd really be better off studying a bit about
relational databases, and using Access instead of Excel for your project. An
inventory control system *can* be designed in Excel, but there will be
moments when you have great ideas that a spreadsheet cannot handle. These
quot;gotchaquot; moments can be avoided by using the right tool to start with. The
link below discusses relational database theory (a bit). If it mentions
particular software, it's not important. You can implement these ideas in
any number of database products.

r937.com/relational.html
A lot of service providers love to do this.
Try them.

quot;WLMPilotquot; gt; wrote in message
...
gt; The county I work for uses a network and MS OUTLOOK (for emailing). Once
a
gt; month, each outlying EMS station fills out a supply reorder, saves it,
signs
gt; onto the network and attaches the workbook to the email and sends it to
the
gt; supply officer.
gt;
gt; I am trying to figure out the best way to set up an inventory control and
gt; have the master inventory quot;filequot; look at each workbook that is downloaded
and
gt; saved (on the supply officer's end) and adjust all the inventory.
gt;
gt; From my little bit of programming knowledge with excel, I have some ideas
gt; but was wondering if anybody might be able to throw some other ideas my
way.
gt;
gt; Basically, my idea consist of having a MASTER inventory control
spreadsheet
gt; for the supply officer. Each station (7 in all) will have a workbook with
12
gt; worksheets predefined with the reorder setup. Unless someone monkeys with
gt; worksheet names, etc., the MASTER spreadsheet would look at each workbook
and
gt; find the correct supply order and pull the numbers and adjust the totals.
gt;
gt; Any ideas are appreciated on this.
gt;
gt; Thanks,
gt; Les