Thank you so much. This worked. And the resource link you gave me is
incredibly useful.
~Addiction
"Rowan Drummond" wrote in message
...
Why not just use Vlookup formulas in row 4 of sheet1 eg:
=VLOOKUP($A$1,Sheet2!$A:$D,2,0)
For more on vlookup see:
http://www.contextures.com/xlFunctions02.html
Hope this helps
Rowan
addiction wrote:
I am a VBA newbie and desperately need to solve a problem for an Excel
spreadsheet I'm building for product sales. Can anyone help me with this
one?
On Sheet1 I want the User to type in the Product Number in Cell A1. This
will search down a random number of rows on Sheet2 in Column A until it
finds a "Match". The data contained within the 4 cells to the right of
the "Match" needs to be printed in Row 4 of Sheet1.
Example:
"Sheet1"
Product No. User Defined
2
Returned Data
3 116 524 727
"Sheet2"
Products Data
5 321 294 112 331
9 456 167 342 72
12 744 221 221 276
7 283 349 98 134
2 3 116 524 727
16 135 81 201 178