Hi,

This workbook has:

1) A PARTS spreadsheet with 500 rows of data with columns such
as Part Number, Description, Quantity, etc.

2) An INVOICE spreadsheet where you specify the Part Numbers,
Quantities and it builds the rest of the invoice for you so
that you can print it.

3) A TRANSACTION spreadsheet that records the transaction after
you are finished with each invoice.

4) The TRANSACTION spreadsheet then updates the respective
Quantities in the PARTS spreadsheet. So PARTS inventory
accuracy is maintained.


All of the above is working just fine.
Moving forward:

a) This workbook was running on 1 PC for 1 user. Now it
needs to be used by 3 users simultaneously from 3 different PCs.

b) So I can move the workbook to file server.


But how:

1) Can I make this a multi-user spreadsheet so that 3
people can use it concurrently?

2) Each of these 3 users will be generating invoices all
day long. The TRANSACTION spreadsheet still needs to update
the respective Quantities in the PARTS spreadsheet. So the
Quantity column in the PARTS spreadsheet needs to hold
the *exact* quantities otherwise the whole PARTS inventory
is going to be completely inaccurate.

3) I can only use Excel and nothing else. It is a small
business and the owner cannot afford to spend on more
software purchases.


Thanks.
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/