Need VBA code to find SAP Key from reference min to max sheet

[johnmacpro]

Dear experts

i have master data with ref sheets like Ref_1,2,3,...etc

i want find SAP KEY from ref's sheet start with min(Reference_2) range of (G2:H3), If concante column G:G match in range get result H:H, once done delete fist 3 row ,bring the next 2 row up. this action get change depends upon ref-sheet
if its Ref_4 delete first 5 row bring up next 3
if its Ref_3 delete first 4 row bring up next 3

loop the action through all sheet once done msg box all sheet done

there is one challenge, if combination order in 1,2 in report data sheet 2,1 need to find exact combination



find the attachment

[davesexcel]

Could you search for the SAP in column A? why would you need to find it in column G?

[johnmacpro]

Its SAP code In Column A but i want result SAP Key ID which is in column H:H

[davesexcel]

Try this,
For test purposes, the code places the results in Sheets("Reporting_Data_Output") column J So we can see that the results match your results.

Please Login or Register  to view this content.

[johnmacpro]

hi sir works fine with your code, but if i reduce sheet getting error ,i run the code with Reference_2 only it getting error.

find the attachment

[jindon]

i want find SAP KEY from ref's sheet start with min(Reference_2) range of (G2:H3), If concante column G:G match in range get result H:H, once done delete fist 3 row ,bring the next 2 row up. this action get change depends upon ref-sheet
if its Ref_4 delete first 5 row bring up next 3
if its Ref_3 delete first 4 row bring up next 3

there is one challenge, if combination order in 1,2 in report data sheet 2,1 need to find exact combination

Fixed the code for the second red part.
This extracts result in order of each sheet according to the first matched row.

Please Login or Register  to view this content.

[johnmacpro]

Thanks alot!! its works as i expected thanks for your valuable time and patient saved me & solved my problem