Select a set of data that matchs a range then input said data into a new column SOS

Okay i tried this in the main forum but had no luck so i'm going to attempt to explain it a little better here.

I have a set of data say Column A and Column B with a varying number of rows as the data is dynamic (i.e. always changing depending on howmany options are available for a specific date)
Column A contains a set of strings and B is the associated value for them.
I need to find a way of extracting all pairs of A&B that have a B that fits between a specific range of numbers say 5 and 10.
I then need these to be replicated in a new set of columns next to it.
These will continously change though as the number of rows in A&B grows or shrinks as i refresh.

How can i do this?

Hi

Have you tried the advanced filter with the output going to a new location?

If this doesn't make sense, then put up an example file and show how the relevant data should be selected and output.

rylo