OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Worksheet Functions (http://www.officefrustration.com/forumdisplay.php?f=3)
-   -   Combining different worksheets using VBA (http://www.officefrustration.com/showthread.php?t=1126387)

jimmy2016 October 13th, 2016 01:59 AM

Combining different worksheets using VBA
 
Combining different worksheets into a single worksheet.

Dear helpers,

I am new to VBA and have the problem:
To combine worksheets into a single worksheet we always use copy and paste but if there are many worksheets, say 30, it will spend a lot of time in selecting and copying.
I want to create a button in sheet1 and onclick it, those tables in the worksheets(named A01,..,A30) will be copied to sheet1, say from sheet1!A15.

1. The worksheets will be of the same number of columns:
A1(name), B11(date), C11(number), D11(price)
but different rows of data.

2. In the workbook, there are other worksheets and the worksheets I want to cope with are A01,...A30 only.

3. The are other data in worksheets A01,...,A30 and the tables I want to copy are, say, A01!A11:P19, A02!A11:P13,....
Can the VBA code count the number of rows in the table in each worksheet?

Thanks for your help.


All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com