Dani
Did "bman" give you what you needed or are you waiting for me?
What do you mean by "But they each one just feed the mastersheet once, at
its respective month"? Expound on that a little. Where is the month in
your data? Do you want to do this just once a month, and if so, how can you
tell which sheet to copy from in what month? HTH Otto
"Dani Lima" wrote in message
...
Otto,
Both worksheets look like that:
colA colb Colc cold
2 Clients'name Accur % total ord total deliv.
3 051 -Danielle
4 098 - Andre
5 110 - Aliine
I wanna copy from the "another" worksheet the names on columm A that
aren't
on the Columm A of the master worksheet to the end of the columm A of
worksheet. The rows with the headers are always the third and the data
starts
always on the fourth.
Yeah, I have more than one "another" worksheet. But they each one just
feed
the mastersheet once, at its respective month.
If possible I'd like them sorted.
thks
Dani
"Otto Moehrbach" escreveu:
Dani
This would have to be done with VBA. Provide details about the
layout
of the data in both sheets. That is, what columns have the names? What
columns do you want copied from one sheet to what columns in the master
sheet? What rows have the headers and in what rows do the data start?
Do
you have more than one "another" sheet? Do you want the master sheet
sorted
after the copying is done? HTH Otto
"Dani Lima" <Dani wrote in message
...
Here is my problem: I have a master worksheet that is feed by another
worksheet every mounth. I have to check on the second worksheet the
mames
of
the clientes that isn't on master worksheet and than extract them to
the
first empty row on master worksheet. After that I have to extract the
clients' deliveries data on the second worksheet to its match on the
master
worksheet. Could you help me?