Copy certain rows to new worksheet

[Dave]

Hi everyone

I have 5 worksheets in my workbook. In each sheet, column A is left
empty for the user to select a number from 1 through 6. This is
actually for ranking the rows (1 being best, 2 second best and so on)

Ranks 1 to 6 might be all on one sheet or they may all be on different
sheets.

I would like to have a summary that will copy these rows (1 through 6)
onto a separate worksheet, done by macro or vba. Perhaps by looping
through each worksheet and doing a copy??

Any help would be appreciated.

Thanks,

Dave

 

[Don Guillett]

Hi everyone

I have 5 worksheets in my workbook. In each sheet, column A is left
empty for the user to select a number from 1 through 6. This is
actually for ranking the rows (1 being best, 2 second best and so on)

Ranks 1 to 6 might be all on one sheet or they may all be on different
sheets.

I would like to have a summary that will copy these rows (1 through 6)
onto a separate worksheet, done by macro or vba. Perhaps by looping
through each worksheet and doing a copy??

Any help would be appreciated.

Thanks,

Dave

I don't quite understand your need. Send a file to dguillett1@
gmail.com with a complete explanation and before/after examples and a
copy of this msg.