merging
 

Hi,

I recieve this list of names every week which contains details of th
people working in our company.... the problem is that the software tha
generates the list deletes the names of people who have left, i want t
keep those names.... so i was thinking if there is a macro which woul
merge the last and the new sheet into one sheet so that i have th
names of people who have resigned(from the last sheet) along with th
new additions (in the new sheet)....

i.e. lets say i have the following data in last sheet:

name | process | manager
a | abc | xyz
b | abc | xyz
c | def | xyz
d | abc | xyz

and i have a new list which has the following data:

name | process | manager
a | abc | xyz
c | def | xyz
d | abc | xyz
e | abc | xyz

so, what i want is :

name | process | manager
a | abc | xyz
b | abc | xyz
c | def | xyz
d | abc | xyz
e | abc | xyz

the way i wanted to do this is a bit complicated....
can i have a sheet named "enter data here" and another sheet name
"database" and when i receive the latest details, i just paste them i
"enter data here", run a macro which would merge this data to the ol
data in the way mentioned above and i will have the final data in th
"database" sheet?

can someone help me write a macro for this??

thanks a ton!!

--
Message posted from http://www.ExcelForum.com