Consolidating sheets
 

I have around 12 sheets with data in the same format, i.e.:
Month Client Amount Quantity Branch Product.

What code colud help me to consolidate all the 12 sheets on the current
sheet, instead of going to each sheet and copy pasting each?

Thanx in advance.
--
Best Regards,

Faraz

Consolidating sheets
 

Hi Faraz

Refer the below link by Ron.
http://www.rondebruin.nl/copy2.htm

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

I have around 12 sheets with data in the same format, i.e.:
Month Client Amount Quantity Branch Product.

What code colud help me to consolidate all the 12 sheets on the current
sheet, instead of going to each sheet and copy pasting each?

Thanx in advance.
--
Best Regards,

Faraz