Hi All,
I'v spent most of the morning trying crack this but I'm at a total loss. I'm trying to make a summary page in a workbook which goes into each sheet, the names of which I don't know and pulls out all of the rows with data in them. I don't know how many rows will be filled in but I am only pulling information from AD&E. Does anyone have any ideas? Here is my code so far....
My problem is then, how do I get it to jump a line down before it starts to insert data from the next sheet etc when I have specified B6?
I'v spent most of the morning trying crack this but I'm at a total loss. I'm trying to make a summary page in a workbook which goes into each sheet, the names of which I don't know and pulls out all of the rows with data in them. I don't know how many rows will be filled in but I am only pulling information from AD&E. Does anyone have any ideas? Here is my code so far....
Code:
Dim LimitA As Long
For Each sh In Worksheets
If sh.Name <> "Actions" And sh.Name <> "summary" Then
Worksheets("Actions").Range("B6:B").Value = sh.Range("A2:A" & LimitA).Value
Worksheets("Actions").Range("C6:C").Value = sh.Range("D2:D" & LimitA).Value
Worksheets("Actions").Range("D6:D").Value = sh.Range("E2:E" & LimitA).Value
End If
Next sh
My problem is then, how do I get it to jump a line down before it starts to insert data from the next sheet etc when I have specified B6?