using two worksheets on Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mochafocha - 25 Jun 2007 07:28 GMT

Hi,

I wanted to do the following -

I have a master database of about 2000 items (with details against each
name). I also generate smaller lists (only names) every week that comprise
items from this list. Now is there any way I can pull out other details about
each item if I have these two worksheets? Any help would be greatly
appreciated.

thanks.

Reply to this Message

Roger Govier - 25 Jun 2007 07:57 GMT

Hi

Use Vlookup
Assuming your data is in a Sheet called Master, in columns A through E,
and your smaller list has entries in column A of a Sheet called List.

In B1 of List enter
=IF($A1="","",VLOOKUP($A1,Master!$A$1:$E$1000,COLUMN(),0))
Copy across through C1:E1 and copy B2:E2 down as far as you wish.

If you are using either more, or less columns than 5, then amend
$A$1:$E$1000 to suit.

Signature

Regards

Roger Govier

> Hi,
>
[quoted text clipped - 10 lines]
>
> thanks.

Reply to this Message

CLR - 25 Jun 2007 16:34 GMT

Another way would be to use a helper column on your main database and just
put a "x" in it for each row you want to reproduce on the othere list and
then use the Data > Filter > Autofilter feature to filter for just those rows
and to create the new list.

Vaya con Dios,
Chuck, CABGx3

> Hi,
>
[quoted text clipped - 7 lines]
>
> thanks.

Reply to this Message

mochafocha - 25 Jun 2007 22:22 GMT

thanks all. Let me give those suggestions a shot. hope it works.

> Another way would be to use a helper column on your main database and just
> put a "x" in it for each row you want to reproduce on the othere list and
[quoted text clipped - 15 lines]
> >
> > thanks.

Reply to this Message

Rate this thread: