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