inventory in excel
 

how can i make an inventory sheet with daily updates

carl

Basics........in column less out column = balance on hand

=A1-B1

OR =SUM(A1:A15)-SUM(B1:B15)

OR do you want a running total as ins and outs occur?

If you have your workbook partially set up, you can email it to me.

Change the dot and at to . and @


Gord


On Mon, 24 Jan 2005 13:17:04 -0800, "carlh2o"
wrote:

I have my lists in columns and I was hoping to find a way to put an in column
and an out column at the end of the page that would add or subtract to the
total every day or every time I close the spread sheet. Is that possible or
should I be looking at using MS access. thanx

"Gord Dibben" wrote:

With great difficulty if that's the only information you have to start with.

Please provide more detail.


Gord Dibben Excel MVP

On Mon, 24 Jan 2005 05:45:03 -0800, "carlh2o"
wrote:

how can i make an inventory sheet with daily updates

Thanx that should do it for now

"Gord Dibben" wrote:

carl

Basics........in column less out column = balance on hand

=A1-B1

OR =SUM(A1:A15)-SUM(B1:B15)

OR do you want a running total as ins and outs occur?

If you have your workbook partially set up, you can email it to me.

Change the dot and at to . and @


Gord


On Mon, 24 Jan 2005 13:17:04 -0800, "carlh2o"
wrote:

I have my lists in columns and I was hoping to find a way to put an in column
and an out column at the end of the page that would add or subtract to the
total every day or every time I close the spread sheet. Is that possible or
should I be looking at using MS access. thanx

"Gord Dibben" wrote:

With great difficulty if that's the only information you have to start with.

Please provide more detail.


Gord Dibben Excel MVP

On Mon, 24 Jan 2005 05:45:03 -0800, "carlh2o"
wrote:

how can i make an inventory sheet with daily updates