copy range

I have a range A3:E70 where A3:E69 have the same formatting and the text in A70:E70 is bold. I want to copy-paste the entire range a number of times with a for ... next-loop. Actually, it's kind of a template system. I make the template A3:E70 and uses it a number of times. How is it possible?

Dear forum member repairman615 provided me with this useful code Sub Transfer() Dim c As Long Dim wsD As Worksheet: Set wsD = Worksheets("Sheet2") 'Data Worksheet. Dim wsR As Worksheet: Set wsR = Worksheets("Sheet3") 'Results Worksheet For c = 2 To 1002 'Loop through 1000...

I've created a workbook which tracks stats for my local pool league. There are team, partner sets and player stats collected per week. I also want to track player stats on a per game basis and this is the reason for the post. I've run into a problem in that I can't copy the range of collected...

I am working on a workload tracking workbook for summarizing employee hours on key projects. The workbook contains multiple worksheets for reporting as well as individual employee worksheets for tracking. Each employee worksheet has an identical structure but the number of worksheets will vary...

Hello all, I'm trying to create a macro to: 1. copy a range of columns (G thru O) but the data is in different rows on different spreadsheets. 2. then paste the data on one spreadsheet but different rows. The data will be placed on the same columns. Thanks in advance.