Macro Loop to Extract Specific Values and Min/Max Values From Column/Rows Range

Originally Posted by starryknight64

In your logic, are you wanting to create 5 new worksheets for every row?

Or just one new worksheet per row?

Or is this all in one new worksheet, just different rows?

All in one new worksheet just different rows.

By the way, will change thread title. Sorry about that.

EDIT - Every new value r will have its own Worksheet rather.