Finding Criteria and copying data

[wxdonar]

Hello everyone.

I have a value in Sheet6.(A1). I need to search Sheet5 Column ("BA") for that number or as close to that number as possible, then take the data on the corresponding row in column "BE" and copy it to sheet6 Column Z. For example if Sheet6(A1) is 17, then search Sheet5 Column (BA) for that number or the closest match. 18 appears in cel BA11 in sheet5 column (BA) which is the closest to 17. Then take the data sarting on row 11 column BE and copy to sheet6 column z.

[walruseggman]

Please Login or Register  to view this content.

[wxdonar]

Hi I am getting a variable not defined on ws5, ws6 and openrow

[walruseggman]

Edit: You may have Option Explicit set up. In that case, either delete that line, or define ALL the variables in the code.

Otherwise, make sure "Sheet5" and "Sheet6" are what the worksheets are actually named (the tab names).

If option explicit, add this right after the sub name:

Please Login or Register  to view this content.

[wxdonar]

@walruseggman I think I am not explaining it well to you. I have attached a sample book on what I am trying to do. The sheets and references cells are a bit different.

1. On Sheet6 Cell A1 I need to take that number and find the closest first time instance match from Sheet4 column "Z", which in the sample is Z10, then take the data from E10 to X10 all the way down to X53, highlighted in yellow, and copy that data starting on Sheet 6 M3.

[walruseggman]

I don't see an attached workbook?