How to merge multiple worksheet data into one.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mosaddeq Aziz - 12 Jun 2007 18:11 GMT

Dear All,

I need to merge multiple worksheets in the same workbook. The headers
are same for all the worksheets. The worksheets contain each months
data now i want to merge them in one worksheet and get the entire
years data in one sheet. Each worksheet has auto filter enabled.

Mosaddeq Aziz

Reply to this Message

Dave Peterson - 12 Jun 2007 20:05 GMT

Maybe you could start by using some of Ron de Bruin's code:
http://www.rondebruin.nl/copy2.htm

> Dear All,
>
[quoted text clipped - 4 lines]
>
> Mosaddeq Aziz

Signature

Dave Peterson

Reply to this Message

Mosaddeq Aziz - 13 Jun 2007 20:35 GMT

Thanks for the link. I will give it a try.

Mosaddeq Aziz

>Maybe you could start by using some of Ron de Bruin's code:
>http://www.rondebruin.nl/copy2.htm
[quoted text clipped - 7 lines]
>>
>> Mosaddeq Aziz

Reply to this Message