I want a Macro that will select the A col and the D col of the
database(database records is variable) and only copy these two col's to the
new sheet

"Vacation's Over" wrote:

select entire area
use advanced filter unique records to sort on column A
and place on the new sheet

if this is what you wanted, record the macro

"Oldjay" wrote:

I have a database that I want to copy the A columm of names with no blank
rows and the D columm of telephone numbers with some blank row to a new
sheet.

Thanks for the help
oldjay