View Single Post
  #2   Report Post  
Scott Orchard
 
Posts: n/a
Default

If you hold down the Ctrl key,
then click on the tab for the worksheet containing the original database and
drag it to the right,
then release the mouse,
you should end up with an exact copy of the original worksheet.
You can then just rename the new worksheet as "copy" or whatever else you
want.
Rgds,
Scott

"lexitollah via OfficeKB.com" wrote in message
...
I have a simple database in one sheet that I update with the Data Form
selection from the toolbar. I need a macro that will copy the entire
database to another worksheet in the same workbook so that I can work with
the copied database without fear of corrupting the original.