Help with Lists

I have a list on one sheet and would like to show the same list on
anothersheet. The problem is, I want the list on sheet2 to be updated at the
same time the list on sheet1 is changed so that both they are always the
same. Both sheets are in the same workbook. Can anyone one help?

Hi Ralphb,

Perhaps something like this in sheet 2 and pulled down far enough to cover
the list in sheet 1.

=IF(Sheet1!A1="","",Sheet1!A1)

HTH
Regards,
Howard

"RalphB" <[email protected]> wrote in message
news:[email protected]...
>I have a list on one sheet and would like to show the same list on
> anothersheet. The problem is, I want the list on sheet2 to be updated at
> the
> same time the list on sheet1 is changed so that both they are always the
> same. Both sheets are in the same workbook. Can anyone one help?
>

Thank you.

"L. Howard Kittle" wrote:

> Hi Ralphb,
>
> Perhaps something like this in sheet 2 and pulled down far enough to cover
> the list in sheet 1.
>
> =IF(Sheet1!A1="","",Sheet1!A1)
>
> HTH
> Regards,
> Howard
>
> "RalphB" <[email protected]> wrote in message
> news:[email protected]...
> >I have a list on one sheet and would like to show the same list on
> > anothersheet. The problem is, I want the list on sheet2 to be updated at
> > the
> > same time the list on sheet1 is changed so that both they are always the
> > same. Both sheets are in the same workbook. Can anyone one help?
> >
>
>
>

I entered this formula and changed the sheet1 to the name of my sheet in both
locations used in the formula. I get a #Ref! error.

The name of my sheet is AddRemoveSupplier. The name of the list is
"suppliers". The label on the list is Suppliers and is located in G3.

So the formula as changed looks like this:

=IF(AddRemoveSupplier!G3="","",AddRemoveSupplier!G3)

Am I doing something wrong?

"RalphB" wrote:

> Thank you.
>
> "L. Howard Kittle" wrote:
>
> > Hi Ralphb,
> >
> > Perhaps something like this in sheet 2 and pulled down far enough to cover
> > the list in sheet 1.
> >
> > =IF(Sheet1!A1="","",Sheet1!A1)
> >
> > HTH
> > Regards,
> > Howard
> >
> > "RalphB" <[email protected]> wrote in message
> > news:[email protected]...
> > >I have a list on one sheet and would like to show the same list on
> > > anothersheet. The problem is, I want the list on sheet2 to be updated at
> > > the
> > > same time the list on sheet1 is changed so that both they are always the
> > > same. Both sheets are in the same workbook. Can anyone one help?
> > >
> >
> >
> >

Hi Ralph,

Weird, I got the Ref thing too. Overcame it by doing this. Enter = in your
sheet 2 cell. Select the 1st sheet and click on G3. Now finish the formula
with ="","", and then reclick G3. Gave me the exact 'looking' formula but
works fine.

I tried a re-enter on your ref formula by F2 > Enter and it brought up
MyDocuments file folder of Excel workbooks....????

On your copy paste formula I deleted everything between the ( ) and did it
manually like above and worked fine. A new one on me.

HTH
Regards,
Howard

"RalphB" <[email protected]> wrote in message
news:[email protected]...
>I have a list on one sheet and would like to show the same list on
> anothersheet. The problem is, I want the list on sheet2 to be updated at
> the
> same time the list on sheet1 is changed so that both they are always the
> same. Both sheets are in the same workbook. Can anyone one help?
>