Need help to extract rows based on drop down list value

  • Hello experts

    I have this application which extracts rows depending on the drop down list in the Data sheet cell G2. If I select a number and run the code, the same number of rows are extracted in the Extract sheet depending on the conditions mentioned in the code. If I select 7 or 120, these 2 are not displaying the result as expected. I need your help to correct the code and get the expected result as shown in the Extract sheet columns F and G.

    Correct code to get 7 and 120 rows right.xlsm

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!