VBA - Automatically copy (and update) specific rows and columns into a seperate worksheet

[nottingham]

Hello all,

I recently posted this thread in the Excel General category but was advised to post this thread in Excel Programming / VBA / Macros. My original thread can be found here:
http://www.excelforum.com/excel-gene...worksheet.html

I was hoping whether there is a vba / macro that can be used for this scenario - please let me know if this is possible. The array formula works great for the example provided however my original worksheet contains 17 worksheets - not sure if a formula is the most efficient way for this.

Please advise. Thanks in advance!

[Richard Buttrey]

See post # 6 in the original thread http://www.excelforum.com/excel-gene...ml#post3749329