inventory in excel

[carlh2o]

how can i make an inventory sheet with daily updates

[Gord Dibben]

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

[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

"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
>
>

[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


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
>>
>>

[carlh2o]

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
> >>
> >>
>
>

[disneyfn44]

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?

[arlu1201]

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.