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/

This clearly requires a database engine with record locking and so forth.

It can't be that small if you have three people sending out invoices all day
and he is running a network.

You can use access for the engine I would think and he might have it if he
purchased office professional level.

While excel offers a shared workbook feature, it doesn't support what you
describe.

If you want a free database, look at MySQL

http://www.mysql.com/

--
Regards,
Tom Ogilvy

"lothario" wrote in message
...
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/

Thanks for the info Tom.



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