try something like this:
I have assumed that the product code you are looking for is entered in
A1 of your active sheet, so that this formula would be put into B1. If
it is not in A1, then you will need to change all references to $A1 (6
of them) to suit your set up. I've also assumed that you have data in
columns A to G of your products sheet - if more then you will need to
adjust $A:$G (3 times).
Once you have it set up correctly to suit your data, copy it across
from B1 into C1:G1, and then you can copy B1:G1 down for as many rows
as you are using.
Note that the formula is all one long formula - be wary of spurious
line breaks that the newsgroup reader might insert.
Hope this helps.
> entered. ?>>
>> My active worksheet is dynamic, in that it will receive a data entry value
>> of "product code" in any row but always within the same column. ?gt;
> The product worksheets from which I wish to retrieve data from are set up>
> with product code in column A and data related to the product are contained>
> on the same row as the product code but within multiple columns. (i.e price>
> in column B, description in column C, weight in column D, etc.) >
> If you understand what I have described God bless you and if you can show m>
> and easy way to do this in Excel God bless me>
> I have a limited technical knowledge of both Access and Excel but I'>
> inclined to believe that what I'm describing is something that should be don>
> using Access. 營 know more about Excel than I do about Access so I'm hopin>
> there is an easy way to do it in Excel>
> Thank you for your indulgence, understanding and any help you can provide.>