Otto

I've just read the answer from "bman", I think it will work, but I was
thinking in something more quick 'cause I have to do it every month in a data
base with at least 20000 rows.

About your questions, I think I don't explain properly, the masterworksheet
will look like this one under. The another one worksheet looks like the first
I draw; it will feed the masterworksheet just with the datas "tot ord" and
"tot deliv" on its columms C and D to the columms "total ord" and 'tot deliv"
from the respective month. The another worksheet always has the same name:
"DPL Clientes Brazil" and it is replaced every month, so I think I won't have
problem in tell what sheet to copy from. Yesterday I've tried the the
formula: if(iserror(procv(......;.....;...;....));ext.text( .....;..;...);"")
but It didn't work properly because of the if not clause, as a result I had
several raws with a space...
I'll keep trying, If i didn't get anything I'll do it manually with the
match clause.

tks

Dani

colA colb Colc cold cole
Colf cold
1 Jul/08
Aug/08
2 Clients'name Accur % total ord tot deliv Accur % total
ord tot deliv
3 051 -Danielle
4 098 - Andre
5 110 - Aliine


"Otto Moehrbach" escreveu:

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?