inventory in excel

G

Gord Dibben

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

Please provide more detail.


Gord Dibben Excel MVP
 
C

carlh2o

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
 
G

Gord Dibben

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
 
C

carlh2o

Thanx that should do it for now

Gord Dibben said:
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
Click to expand...
 
Top