Copy info from master sheet to new worksheet

[thomasks]

Hi all,
A coworker of mine has asked if I could take the data that is on a master worksheet in excel, and enable a way to highlight(select) rows. Then have a dialog box pop up and ask the user what the new worksheet name should be, then copy the selected data to the new sheet. After that has been done he wants the copied data on the master sheet to either change color, or bold or something to show that these rows have already been done. Can anyone point me to code to do this?
Thanks

 

[missinglinq]

This is a MS Access forum! You need to move this to:
VBA Visual Basic for Applications (Microsoft) Forum.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[thomasks]

Oops sorry wrong forum, I have moved it.