hi everyone!
ok so here is a very basic explanation of what if would like to do:
in a workbook with multiple sheets, i would like to extract certain rows of data onto a summary sheet. whether or not the information is extracted will depend on a number in column "E". the hoped for response is that all title, non-complete or ref data will be ignored while all the data i require will be copied over! sounds simple enough...
check worksheet 1, column E, for digits.
Copy that entire row if a digit is found, to a "mastersheet".
Repeat for all worksheets (obviously without the mastersheet).
Stop when complete.
This is a piece of code i have been given:
i understand aspects of this, but i would love to know how this might be modified for my requirements.Private Sub Workbook_Open() Dim LstRw As Long Dim Ws As Worksheet For Each Ws In Worksheets If Not Ws.Name = "Master RDS" Then LstRw = Ws.Range("A" & Rows.Count).End(xlUp).Row Ws.Range("A1:A" & LstRw).EntireRow.Copy Destination:=Sheets("Master RDS").Range("A" & Rows.Count).End(xlUp).Offset(1) End If Next Ws End Sub
Any help would be amazing!
Alec
Bookmarks