copy database to another sheet

  • Thread starter lexitollah via OfficeKB.com
  • Start date
L

lexitollah via OfficeKB.com

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.
 
S

Scott Orchard

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
 
V

vince cichosz via OfficeKB.com

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"
 
Top