Help with Lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RalphB - 22 Feb 2006 22:28 GMT

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?

Reply to this Message

L. Howard Kittle - 22 Feb 2006 22:43 GMT

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

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

Reply to this Message

RalphB - 25 Feb 2006 16:01 GMT

Thank you.

> Hi Ralphb,
>
[quoted text clipped - 12 lines]
> > 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?

Reply to this Message

RalphB - 25 Feb 2006 20:05 GMT

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?

> Thank you.
>
[quoted text clipped - 14 lines]
> > > 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?

Reply to this Message

L. Howard Kittle - 26 Feb 2006 20:13 GMT

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

Reply to this Message