Copy certain rows to new worksheet


D

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
 
Ad

Advertisements

D

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 [email protected]
gmail.com with a complete explanation and before/after examples and a
copy of this msg.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top