Hi,
I want to merge two databases which have the same exact
columns. I do this every other day and the databases vary
in the number of rows. By the way, they're located in the
same source worksheet.

Basically, I want to copy one of the databases and add it
to the other database (without copying the header).

Also since I have formulas and pivot tables using the
combined data, I want to name the range as "Data3".

I've tried searching for something similar in the past 6
months here but couldn't easily find anything relevant.

Thanks in advance,
Mr D