Hi all, I have been trying to deal with this issue by myself during the last 2 weeks, but I am giving up...

For each of the following rows, I need to create a new worksheet based on the following info (see below) and the following filters:

Symbol CallPut Strike Price
A130420P00042000 P 42 0.83
A130420P00041000 P 41 0.55
A130420P00040000 P 40 0.37
A130420P00039000 P 39 0.25
A130420P00038000 P 38 0.16
A130420P00035000 P 35 0.04
Starting from the first one, A130420P00042000, I need to calculate 10% of the strike and copy in the following rows the next symbols smaller values (only consider integers, for 4.2 only 4 will be considered and for 3.8 only 3...). As an example:

- A130420P00042000 (row being evaluated, and copy the next 4 smaller rows -resulting from calculating 10% of 42 and taking only the integer).

This is how the new table should look, filtering the first 3 rows (the idea is to do it for all the rows available)

A130420P00042000 (42, 1st row evaluated and next4 )
A130420P00041000
A130420P00040000
A130420P00039000
A130420P00038000
A130420P00041000 (41, 2nd row evaluated, and next 4)
A130420P00040000
A130420P00039000
A130420P00038000
A130420P00035000
A130420P00040000 (40, 3rd row evaluated, and next 4)
A130420P00039000
A130420P00038000
A130420P00035000

A130420P00039000 (39, 4th row evaluated and next 3 -this is because 10% of 39 is 3.9 but we only take the integer into consideration. Anyhow... only 2 rows are still available, so I need to copy only those)
A130420P00038000
A130420P00035000

I will REAAAALLLY appreciate your help, as I am totally lost about how to do this filter!!

Thank you in advance and look forward to reading you!
Hernán