copy database to another sheet
 

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.

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.

Thanks,

This works but copies the entire sheet. I really only want to copy the
portion named Data base which is an ever changing range with daily additions.
Furthermore, the database includes some cells that lookup from a list based
on adjacent cell entries. Copying copies the lookup formula in the cells - I
really want only the values or test from those cells to be "copied"

--
Message posted via http://www.officekb.com