Retrieve product information from another sheet

[Zed1]

Hi, I'm having some trouble getting started with a macro I need.
The macro will use the code from sheet 1 and match it up with the code on sheet 2 (they will not be in the same order) and it will then pull the information about the product from sheet 2 to sheet 1.

Could anyone please help me out?

*Attachment in a post below

[Pete_UK]

You can do it with a simple formula - put this in B1 of Sheet1:

=IFERROR(VLOOKUP($A1,Sheet2!$A:$C,COLUMNS($A:B),0),"")

then copy across and down as required.

Hope this helps.

Pete

[Zed1]

Oh my apologies, the example wasn't quite correct. On sheet 1 the item codes would be horizontal instead of vertical so Vlookup can't work here.
I'd really prefer it to be in VBA if possible as I'll also be using other bits of code to edit it.

[Zed1]

So it'd be like this, except with hundreds of records

[Pete_UK]

You could use this formula in A2 of Sheet1:

=IFERROR(VLOOKUP(A$1,Sheet2!$A:$C,ROWS($1:2),0),"")

then copy across and down as required. Note: VLOOKUP is still used, as your source data is still arranged vertically, even though you want the output to be horizontal.

Sorry, I rarely write macros anymore - maybe someone else will chip in.

Hope this helps.

Pete

[AB33]

If you want a code.

[IonutC]

Here you go. Hope it helps

[IonutC]

AB33,
Can you please explain the logic of your code. I haven't seen a transpose code like that until now.

I don't understand this part.

Please Login or Register  to view this content.

Thank you,
Ionut

[AB33]

Which part? You copied the entire code. Transpose works the same as excel's transpose function. It flips over the rows in to columns and vice versa.

[Zed1]

If you want a code.

This is working great, thankyou very much!

Also thanks to IonutC and Pete_UK for attempting this as well

[IonutC]

yeah i know...each line of your code. if you are busy, no worries.