combining lists in Excel

[thehustler]

Hi folks, long time lurker, but first time poster.

I am looking for some assistance along the lines of this topic here http://www.excelforum.com/excel-prog...-workbook.html which I found when I searched.

However - what I am looking for is 10 sheets of identical data, from 10 different sites to feed into one master sheet which I will use to provide stats etc. The 10 sheets will have around 5-600 entries on it each day, and I will have no way of knowing when and how many there will be. i was looking at the paste link function, but this does not allow me the flexibility of an unknown/non specific number of entries.

How would I go about modifying the above script to do this for me please? I'm ok with vba, but still very much a beginner, so any help would be appreciated. Thank you

[blane245]

Glad to see you posting!

Here's a macro that copies the entiore contents from the first 110 worksheets to the 11th. Maybe it will help you get started.

Please Login or Register  to view this content.

[snb]

Without copying

Please Login or Register  to view this content.

[blane245]

Without copying

you are so clever!

[thehustler]

Thanks very much guys.

snb, what do you mean - without copying? Do you mean that when the person nputs it to their sheet it will automatically also enter it on my master? ie - it just takes the values from the appropriate cells?