rangudu_2008
08-05-2010, 07:20 PM
Hi,
I found a KB entry suggesting about this topic, but to suit my requirement, i need to tweak the code in such a way that i need to consolidate data from all worksheets in a workbook which start with a definite word ("Sample_xxx - xxx denotes some 2-digit or 3-digit number). How can that be done?
The KB entry for this topic is as below:
Combine All Worksheets into One
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151 (http://www.vbaexpress.com/kb/getarticle.php?kb_id=151)
Ranga
I found a KB entry suggesting about this topic, but to suit my requirement, i need to tweak the code in such a way that i need to consolidate data from all worksheets in a workbook which start with a definite word ("Sample_xxx - xxx denotes some 2-digit or 3-digit number). How can that be done?
The KB entry for this topic is as below:
Combine All Worksheets into One
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151 (http://www.vbaexpress.com/kb/getarticle.php?kb_id=151)
Ranga