Hi:
I am new to VBA. I wonder if there is a marco which I can use to copy
all the nonblank rows from many worksheets and paste them onto one
single worksheet (as text). For example, say I got sheet1, sheet2,
sheet3 and I want to copy all the nonblank cells (except the first row,
which is the title row) of the worksheets to sheet4 as text, so that
all the data will appear on one single sheet. Anyone can help? Thanks
heaps!
Regards,
Starman
Bookmarks