MODIFY COPY/PASTE code using multiple sheets
Posted on 2006-11-09
I need a code to copy data from multiple worksheets (Workbook1, all of the ranges are the same on each sheet =B3:X53). Paste data into another Workbook2 (worksheet is the same="hour_data" but the ranges are not the same). I use the following formula to copy and paste data from single worksheets. Please explain how to maybe use Loop to prevent from copying (for each sheet) this formula 25times.
**There are a few sheets in Workbook1 that I do not want to copy. All of the worksheets in Workbook1 are labeled (sheet.name).