Copy Varying Range Sizes from Multiple Sheets to Main Sheet

Hi Guru's

I have couple of issues and questions with this Macro.

1.) Is there a way to change the reference point (starting point) when it copies the information from each sheet. I am having problems because it starts at "A1" on each sheet and really need it to start at "B1"

2.) Data (row) fails to copy if I have missing data in column A even though I might have data in consecutive columns. Is there a way to make the count rows function look at cells A:F?

I have attached a file, that will probably explain better my situation and it contains the macro in quesiton.

Any help would be much appreciated.

-Wesley

Hello,

I reprogrammed your code.*Try my version.

Please Login or Register  to view this content.

Best regards.

PMO
Patrick Morange