(Solved) – Extract Rows with Lowest values in Excel VBA Macros [closed]

(solved)-–-extract-rows-with-lowest-values-in-excel-vba-macros-[closed]

My Excel Sheets Looks like this:

Sheet Name: “My Hours”

Name Position Hours

a
School
10

b
School
20

c
School
30

d
college
5

e
college
4

f
college
3

I made an input excel sheet as

Sheet “Input”

Position
Number

School 2

College 1

So, in my output table, the following should be extracted:

Sheet “Output:”

Name Position Hours

a
School
10

b
School
20

d
college
3

which is 2 lowest rows of school and 1 lowest row for college.

How can I do this in Excel macro, my running a Excel VBA macro with a button, after filling Inputs?

Leave a Reply

Your email address will not be published. Required fields are marked *