Send me an email address (I tried to send you an email but it bounced back
to me). Send to n e w d o v e r m a n @ y a h o o . c a (take out the
spaces.

If you include your inventory list and prices, and order points, I could
populate the tables to perform the calculations using your data in the
sheet.

Ron

"anjarama" wrote in message
...
OH PLEASE!!!
I am near pulling my hair out.
Many thanks.
I am running Office 2007, so it should work.
Thank you, Thank you..

"Bogey Man" wrote:

I have a very simple spreadsheet that that can be expanded and does most
of
what you want and a little more. If you would like it, I could send it to
you. It is currently in Excel 2007 format but I can save it in a
different
format if that is what you require.

The sheet is populated with dummy data to give an idea of what is
happening
with the calculations.

Let me know if you are interested.


"anjarama" wrote in message
...
I am no pro in Excel. Please, I need to figure out how to create an
inventory speadsheet that will update the current inventory when saved.

A1) product B1) amt sold C1) price per unit D1) original inventory E1)
D1-B1

I'de like to save the updated E1 inventory after each order, clear B1
for
the next order and have E1 always reflect the current stock.

If I save and clear B1, E1 reverts back to D1 quantity.

Thanks for any help.