I want to loop through 10 worksheets in my workbook (sheet1, sheet2...sheet10) and copy the data from A1 in each sheet and paste into column A in sheets("data"). Sheets("data") is part of the same workbook.
Many thanks in advance
I want to loop through 10 worksheets in my workbook (sheet1, sheet2...sheet10) and copy the data from A1 in each sheet and paste into column A in sheets("data"). Sheets("data") is part of the same workbook.
Many thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks