Multiple Work Sheets

[Daniell]

I have a project that involves 6 worksheets all in the same workbook. What I
need to do is get data from all the worksheet by a part number which is
common in all the worksheets. For example the driver worksheet has a
partnumber and datein field. The second worksheet has the partnumber,
storenumber, reorder point, leadtime, and others. The third worksheet has
the quanity, cost of last purchase, date of last purchase, cost at previous
purchase, date of previous purchase and so on. The fourth worksheet has the
partnumber, and all of the different other partnumbers that make the primary
partnumber.

I guess to make a long story short is there a function that I can use to
read the first worksheet partnumber and then go to the second, third, fourth
and so on and place all the data in another worksheet with all the cell from
previous worksheets rerquested?

That in advance for the help.

[Otto Moehrbach]

Daniell
The VLookup formula does what you want. Look it up in Help. However,
using the VLookup formula when you have lots of data can be messy. If you
have a great deal of data, I would recommend a VBA solution. Post back if
this interests you. HTH Otto
"Daniell" <Daniell@discussions.microsoft.com> wrote in message
news:14DCDC82-EEF8-4D7B-9FE5-6F8379EE735F@microsoft.com...
>I have a project that involves 6 worksheets all in the same workbook. What
>I
> need to do is get data from all the worksheet by a part number which is
> common in all the worksheets. For example the driver worksheet has a
> partnumber and datein field. The second worksheet has the partnumber,
> storenumber, reorder point, leadtime, and others. The third worksheet has
> the quanity, cost of last purchase, date of last purchase, cost at
> previous
> purchase, date of previous purchase and so on. The fourth worksheet has
> the
> partnumber, and all of the different other partnumbers that make the
> primary
> partnumber.
>
> I guess to make a long story short is there a function that I can use to
> read the first worksheet partnumber and then go to the second, third,
> fourth
> and so on and place all the data in another worksheet with all the cell
> from
> previous worksheets rerquested?
>
> That in advance for the help.

[Daniell]

The amount of lookups I would have at one time may be 125. I am not sure if
that would be to much or not. Each of the worksheets have arount 300 rows
with 15 to 23 colums.

"Otto Moehrbach" wrote:

> Daniell
> The VLookup formula does what you want. Look it up in Help. However,
> using the VLookup formula when you have lots of data can be messy. If you
> have a great deal of data, I would recommend a VBA solution. Post back if
> this interests you. HTH Otto
> "Daniell" <Daniell@discussions.microsoft.com> wrote in message
> news:14DCDC82-EEF8-4D7B-9FE5-6F8379EE735F@microsoft.com...
> >I have a project that involves 6 worksheets all in the same workbook. What
> >I
> > need to do is get data from all the worksheet by a part number which is
> > common in all the worksheets. For example the driver worksheet has a
> > partnumber and datein field. The second worksheet has the partnumber,
> > storenumber, reorder point, leadtime, and others. The third worksheet has
> > the quanity, cost of last purchase, date of last purchase, cost at
> > previous
> > purchase, date of previous purchase and so on. The fourth worksheet has
> > the
> > partnumber, and all of the different other partnumbers that make the
> > primary
> > partnumber.
> >
> > I guess to make a long story short is there a function that I can use to
> > read the first worksheet partnumber and then go to the second, third,
> > fourth
> > and so on and place all the data in another worksheet with all the cell
> > from
> > previous worksheets rerquested?
> >
> > That in advance for the help.
>
>
>

[Otto Moehrbach]

Do you mean 125 VLookups for each part number?? I recommend the VBA
solution. It is simple and easy to change. If you wish, send me direct a
small file with a sample of what you have to start with and what you want to
finish with. I'll work up something for you to work with. Also tell me the
version of Excel that you are using.
My email address is ottomocobia97@bellsouth.net. Remove "cobia97" from
this address. HTH Otto

"Daniell" <Daniell@discussions.microsoft.com> wrote in message
news:A2D8CD40-1686-49D6-88F4-EE9AFAA3C434@microsoft.com...
> The amount of lookups I would have at one time may be 125. I am not sure
> if
> that would be to much or not. Each of the worksheets have arount 300 rows
> with 15 to 23 colums.
>
> "Otto Moehrbach" wrote:
>
>> Daniell
>> The VLookup formula does what you want. Look it up in Help.
>> However,
>> using the VLookup formula when you have lots of data can be messy. If
>> you
>> have a great deal of data, I would recommend a VBA solution. Post back
>> if
>> this interests you. HTH Otto
>> "Daniell" <Daniell@discussions.microsoft.com> wrote in message
>> news:14DCDC82-EEF8-4D7B-9FE5-6F8379EE735F@microsoft.com...
>> >I have a project that involves 6 worksheets all in the same workbook.
>> >What
>> >I
>> > need to do is get data from all the worksheet by a part number which
>> > is
>> > common in all the worksheets. For example the driver worksheet has a
>> > partnumber and datein field. The second worksheet has the partnumber,
>> > storenumber, reorder point, leadtime, and others. The third worksheet
>> > has
>> > the quanity, cost of last purchase, date of last purchase, cost at
>> > previous
>> > purchase, date of previous purchase and so on. The fourth worksheet
>> > has
>> > the
>> > partnumber, and all of the different other partnumbers that make the
>> > primary
>> > partnumber.
>> >
>> > I guess to make a long story short is there a function that I can use
>> > to
>> > read the first worksheet partnumber and then go to the second, third,
>> > fourth
>> > and so on and place all the data in another worksheet with all the cell
>> > from
>> > previous worksheets rerquested?
>> >
>> > That in advance for the help.
>>
>>
>>

[Otto Moehrbach]

Daniell
I just changed my email address. It is ottokmnop@comcast.net. Remove
"nop" from this address. HTH Otto
"Otto Moehrbach" <ottomocobia97@bellsouth.net> wrote in message
news:upn098%23$EHA.1400@TK2MSFTNGP11.phx.gbl...
> Do you mean 125 VLookups for each part number?? I recommend the VBA
> solution. It is simple and easy to change. If you wish, send me direct a
> small file with a sample of what you have to start with and what you want
> to finish with. I'll work up something for you to work with. Also tell
> me the version of Excel that you are using.
> My email address is ottomocobia97@bellsouth.net. Remove "cobia97" from
> this address. HTH Otto
>
> "Daniell" <Daniell@discussions.microsoft.com> wrote in message
> news:A2D8CD40-1686-49D6-88F4-EE9AFAA3C434@microsoft.com...
>> The amount of lookups I would have at one time may be 125. I am not sure
>> if
>> that would be to much or not. Each of the worksheets have arount 300
>> rows
>> with 15 to 23 colums.
>>
>> "Otto Moehrbach" wrote:
>>
>>> Daniell
>>> The VLookup formula does what you want. Look it up in Help.
>>> However,
>>> using the VLookup formula when you have lots of data can be messy. If
>>> you
>>> have a great deal of data, I would recommend a VBA solution. Post back
>>> if
>>> this interests you. HTH Otto
>>> "Daniell" <Daniell@discussions.microsoft.com> wrote in message
>>> news:14DCDC82-EEF8-4D7B-9FE5-6F8379EE735F@microsoft.com...
>>> >I have a project that involves 6 worksheets all in the same workbook.
>>> >What
>>> >I
>>> > need to do is get data from all the worksheet by a part number which
>>> > is
>>> > common in all the worksheets. For example the driver worksheet has a
>>> > partnumber and datein field. The second worksheet has the partnumber,
>>> > storenumber, reorder point, leadtime, and others. The third worksheet
>>> > has
>>> > the quanity, cost of last purchase, date of last purchase, cost at
>>> > previous
>>> > purchase, date of previous purchase and so on. The fourth worksheet
>>> > has
>>> > the
>>> > partnumber, and all of the different other partnumbers that make the
>>> > primary
>>> > partnumber.
>>> >
>>> > I guess to make a long story short is there a function that I can use
>>> > to
>>> > read the first worksheet partnumber and then go to the second, third,
>>> > fourth
>>> > and so on and place all the data in another worksheet with all the
>>> > cell
>>> > from
>>> > previous worksheets rerquested?
>>> >
>>> > That in advance for the help.
>>>
>>>
>>>
>
>