using two worksheets on Excel
 

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.

using two worksheets on Excel
 

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,COLU MN(),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.

--
Regards

Roger Govier


"mochafocha" wrote in message
...
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.

using two worksheets on Excel
 

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



"mochafocha" wrote:

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.

using two worksheets on Excel
 

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

"CLR" wrote:

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



"mochafocha" wrote:

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.