inventory in excel

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"
> <carlh2o@discussions.microsoft.com> wrote:
>
> >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"
<carlh2o@discussions.microsoft.com> 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"
>> <carlh2o@discussions.microsoft.com> 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"
> <carlh2o@discussions.microsoft.com> 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"
> >> <carlh2o@discussions.microsoft.com> wrote:
> >>
> >> >how can i make an inventory sheet with daily updates
> >>
> >>
>
>

I am looking to do the same thing. I have been racking my brain to find an easy solution. I have an existing inventory that we take from daily. We add to it daily as well. I need to be able to have a total at the end of each day in order to enter the next days. Can someone help me?