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!A1.
The worksheets will be of the same number of columns:
A1(name), B1(date), C1(number), D1(price)
but different rows of data.
Can the VBA code count the number of rows in each worksheet?
Thanks for your help.