Prev: Multiple formulas in subtotal
Next: How do I create fee structured sliding scale?
From: natty2506 on 3 Feb 2010 10:39
Please can you help with this.

I have 6 workbooks with one sheet in each that is identical - with text data
in

I need to design a 'master' sheet that when one is updated so is the master.

The amount of rows will differ for each sheet but the column names are the
same in the same place.

Thanks is advance
From: Luke M on 3 Feb 2010 10:52
Check out Ron's site, especially the section about halfway down dealing with
Copy/Paste/Merge.
http://www.rondebruin.nl/tips.htm

He has several ways of combining multiple sheets and/or workbooks into a a
summary workbook/worksheet/csv file.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"natty2506" wrote:

> Please can you help with this.
>
> I have 6 workbooks with one sheet in each that is identical - with text data
> in
>
> I need to design a 'master' sheet that when one is updated so is the master.
>
> The amount of rows will differ for each sheet but the column names are the
> same in the same place.
>
> Thanks is advance
 | 
Pages: 1
Prev: Multiple formulas in subtotal
Next: How do I create fee structured sliding scale?