Fetching data from another Worksheet

[Jhedge]

(Posted also in General Forum)

Hello ,

I need to perform a task and wanted to ask someone if it can be done.

I have a worksheet that is used for inventory.

The worksheet is being used to build an parts catalog.
Items are broke down by catagory.
There may be only a 100 - 500 parts in the sheet and all of them are in the same catagory.
So in other words there is a sheet for every catagory.

Example:Sheet maybe named "Hand Tools" another may be "Power Tools"
You get the ideal..

It has about three columns. (could be more but does not matter)

Col A- Part Nbr
Col-B- Description
Col-C- Cost

We will call the catagory sheet -- "Sheet A"

I have another worksheet that has the same information but it is the complete inventory about 10,000 items.

We will call this sheet -- "Master"

Now that I have said all of that, this is what I need to do.

Look for "Part Nbr" in "Master" that matches "Part Nbr" in "Sheet-A"
Get the "Cost" of that "Part Nbr" (from the column were it is at) and move that cost to "Sheet - A".

I know that this is a bit worded but I want to be sure that it makes sence.

At least I hope it does!

Just some how loop through the hole sheet and get the data .

This might be easy but I need some help please.

Thanks for your time,

Jim

--------------------------------------------------------------------------------
Last edited by Jhedge : Today at 09:36 PM.

[Bryan Hessey]

(Posted also in General Forum)

there is no reason to double post, you just waste time, and not just your own.

Hello ,

I need to perform a task and wanted to ask someone if it can be done.

I have a worksheet that is used for inventory.

The worksheet is being used to build an parts catalog.
Items are broke down by catagory.
There may be only a 100 - 500 parts in the sheet and all of them are in the same catagory.
So in other words there is a sheet for every catagory.

Example:Sheet maybe named "Hand Tools" another may be "Power Tools"
You get the ideal..

It has about three columns. (could be more but does not matter)

Col A- Part Nbr
Col-B- Description
Col-C- Cost

We will call the catagory sheet -- "Sheet A"

I have another worksheet that has the same information but it is the complete inventory about 10,000 items.

We will call this sheet -- "Master"

Now that I have said all of that, this is what I need to do.

Look for "Part Nbr" in "Master" that matches "Part Nbr" in "Sheet-A"
Get the "Cost" of that "Part Nbr" (from the column were it is at) and move that cost to "Sheet - A".

I know that this is a bit worded but I want to be sure that it makes sence.

At least I hope it does!

Just some how loop through the hole sheet and get the data .

This might be easy but I need some help please.

Thanks for your time,

Jim

--------------------------------------------------------------------------------
Last edited by Jhedge : Today at 09:36 PM.

In the cell where you want the price,

=VLookup(A1,Master!A:C,3,False)

and formula fill that down the page.

http://www.mvps.org/dmcritchie/excel/fillhand.htm shows Formula Fill.

hth
---

[Jhedge]

Bryan,

Thanks!!

I will give that a try.

Jim