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

On Sep 15, 6:03*am, Dave <Dave.Bea...@lhsc.on.ca> wrote:
> 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.