Need code to copy and paste based on variable rows

Hello
I am writing a macro to combine a few different different spreadsheet.
Out team individiually type out a list of dailt deliverables.
Every morning, someone manually goes in an grabs all the rows in everyone's files and combines then in a master file.
The amount of rows changes day to day based on work load.
But I am not sure the code to use to select only the rows that have data in them.
Can anyone help with that code??
Thanks
Bonnie

Mandy 4.30.13.xlsxMaster Deliverables Spreadsheet 4.30.13.xlsxRich 4.30.13.xlsx

I need something that will go out and open each one and copy and past into master under the last one, so the cells will always ver variable.
Thanks!

Hi Holger, this is my code, can you let me know where I should put the above code in?
Also, do you know what code I would use to add a subject into the email listed in the code??
Thank you so much!!

Please Login or Register  to view this content.

Hi Holger
This worked perfectly!!
The files are in all different folders, I think I am going to make everyone use a standard file name, only their name on their current file, so I don't have the build the dates into the file names, it would be a pain with people not updating and weekends. My last question for you is I need to copy over the the Values and Number formats, the master does not have the coloring we use for the file. Please let me know what I can do you copy that over.
Thanks soooo much!!!

Bonnie

Hi Holger
Not sure that will work, I am using your code to copy and paste the different ranges:
How to I add it into this code?

Please Login or Register  to view this content.

Here is the source file and the master.
How would I go about setting in the formatting since the rows change daily in all the different lists?
Thanks
Bonnie