Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook looping to many worksheets
Hi Dave,
Works perfectly! Thanks a ton for the help. Regards, Howard "L. Howard Kittle" wrote in message ... Hello Excel Experts and Users, This code from Bernie Deitrick works fine for the example I provided in a previous post. It works because the sheets in test workbook B are named sheet1, sheet2, sheet3 etc. The four columns in each row of data in Range("B2:E11") are nicely transposed to the various sheets in book B. In reality the names of the sheets in the real workbook B are names like Adams, Allen, Brown, Cuyahoga, etc. A list of these names are in column A of workbook A, Sheet1 A2:A11. (there are 88 names but I am using 10 in my testing) How can I pass these names to the PasteSpecial & Transpose code line similar to how iSht increments the row number, except I get the next row name each time. Instead of ...Workbooks("B.xls").Worksheets("Sheet" & iSht). _ How can I ...Workbooks("B.xls").Worksheets("increment names 1 row at a time"). _ Sub Reconstruct_To_Source() Dim myRow As Range Dim iSht As Integer Application.ScreenUpdating = False iSht = 1 For Each myRow In Workbooks("A.xls"). _ Worksheets("Sheet1").Range("B2:E11").Rows myRow.Copy Workbooks("B.xls").Worksheets("Sheet" & iSht). _ Range("IV5").End(xlToLeft).Offset(0, 1).PasteSpecial _ xlPasteValues, Transpose:=True iSht = iSht + 1 Next myRow Application.ScreenUpdating = True Application.CutCopyMode = False End Sub Thanks for any help. Regards, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping a column in workbook 1 to workbook 2's sheets | Excel Programming | |||
Looping through Worksheets | Excel Programming | |||
Looping worksheets in workbook | Excel Programming | |||
Looping Through Worksheets In A Workbook | Excel Programming | |||
looping through worksheets | Excel Programming |