Checking empty cells

Hello,

I'm having 4 sheets in a XLS named sheet1,2,3 and total.

I have 3 emploies and each one will complete an individual sheet, for example emploie john will make a list with all of his clients in sheet1, mark in sheet2,by columns etc.

I've built a macro that takes the informations from the first 3 sheets and centralize it in the "total" sheet.

However, the number of clients that each individual emploie has isn`t the same each month. So i want my program to take info from sheet1, put it nicely in total, then automaticaly detect the empty row and take the info from sheet2 and put it right from there, and so on for sheet3.

If anyone could help me i would be grateful, please note that my experience with VBA is limited and i could use some explicit hints.

Thanks and sorry for my bad english.

Hi Diez,

Youo can determine the first empty cell in column A of the Total sheet thus:

Dim destRng As rng

Set destRng = Sheets("Total").Cells(Rows.Count, "A").End(xlUp)(2)


Therefore, you could perform the copy operations something like:

Set destRng = Sheets("Total").Cells(Rows.Count, "A").End(xlUp)(2)
Sheets("John").Range("A2:D50").Copy Destination:= destRng
Set destRng = Sheets("Total").Cells(Rows.Count, "A").End(xlUp)(2)
Sheets("Mark").Range("A2:D100").Copy Destination:= destRng
Set destRng = Sheets("Total").Cells(Rows.Count, "A").End(xlUp)(2)
Sheets("Fred").Range("A2:D75").Copy Destination:= destRng



---
Regards,
Norman


"Diez" <Diez.29qiw0_1150864203.6639@excelforum-nospam.com> wrote in message
news:Diez.29qiw0_1150864203.6639@excelforum-nospam.com...
>
> Hello,
>
> I'm having 4 sheets in a XLS named sheet1,2,3 and total.
>
> I have 3 emploies and each one will complete an individual sheet, for
> example emploie john will make a list with all of his clients in
> sheet1, mark in sheet2,by columns etc.
>
> I've built a macro that takes the informations from the first 3 sheets
> and centralize it in the "total" sheet.
>
> However, the number of clients that each individual emploie has isn`t
> the same each month. So i want my program to take info from sheet1,
> put it nicely in total, *then automaticaly detect the empty row* and
> take the info from sheet2 and put it right from there, and so on for
> sheet3.
>
> If anyone could help me i would be grateful, please note that my
> experience with VBA is limited and i could use some explicit hints.
>
> Thanks and sorry for my bad english.
>
>
> --
> Diez
> ------------------------------------------------------------------------
> Diez's Profile:
> http://www.excelforum.com/member.php...o&userid=35614
> View this thread: http://www.excelforum.com/showthread...hreadid=553914
>