I have a workbook that contains 2 worksheets that contain the raw data the user will be working with. This data changes daily so I cannot use a filter. I need to look up the Run Number listed within the RawData sheet on the Table sheet and then bring over the Quantity Detail. There can be more than one instance of the Run Number to reflect the different quantity details. I need to bring each instance over horizontally. I am attaching the spreadsheet.

Attached Files

QTYDetailTable.xlsx (42.0 KB, 16 views)

hi jrpey,

See: http://lounge.windowssecrets.com/ind...owtopic=771787
and:
http://www.techsupportforum.com/micr...la-issues.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,
I checked out both of the links. The problem is that the data I am going to retrieve is in the same column. There are only 2 columns in the table I am trying to retrieve data from. The Run Number I am looking for is in column A and the data I want is in column B. The problem is that there will be more than one instance of the Run Number within the table. The data in column B will be different for each instance. So what I need to do is pull over every instance.

hi jrpey,

That's exactly what the solution I posted in those other forums provides for. Granted, those solutions pull over muliple columns of data, but the first two columns in the output table have all you'll need.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]