macro to copy row to new worksheet

[Krivo666]

Hi,

wonder if anybody could help me out with macro for copying row to new worksheet

I have values in column H ranging from 1.01 to 8, I need macro to copy any row which includes 1.00-1.49 in column H, to new worksheet.

also if possible, to create new worksheet for each range: 1.00-1.49, 1.5-19, 2.00+, so at the end I would end up with 3 new worksheet for each range with whole row copied to respective worksheet

any help will be appreciated

[oeldere]

@krivo666

1) Please add your workbook.

2) What is the reason you want to do it that way (printing?)?

[Krivo666]

odds.xlsx

I need to do some calculations with each range, and thought it would be easier to extract them into new sheets

[oeldere]

Which calculations do you want to do.

Maybe it is not nessesary to extract.

[Krivo666]

what I'm trying to do is get R.O.I for each range of odds, 1-1.3, 1.3-1.5, 1.5-1.7 etc. to see which is profitable and which not, therefore need some system to separate them, and then do calculation, and thought extracting them and moving to separate worksheet might be easiest.

[oeldere]

Maybe like this.

with VLookup and pivot table.

Do you have questions, just ask.