Hi all- I’m really struggling with the last step of my variance reporting for my company. I have a workbook with 30 or so sheets. Each section of business has 3 sheets. One of these sheets has been formatted to highlight certain variances that need explanation. I want to create a summary sheet that pulls the headers of each of these specific sheets, and then all lines that have the conditional formatting and then repeating through the workbook. Right now I am able to get it to create the summary sheet and pull all headers but can’t figure out how to add the data!!!
Code:
`For Each ws In wb.Worksheets`
`ws.Activate`
`If ws.Range("a2") = "Budget Comparison" Then`
`' copy and paste headings to first empty row in the Summary sheet`
`lastrow = Sheets("Summary of Variances").Range("A" & Rows.Count).End(xlUp).Row`
`Range("A1,A2,A5,A6").EntireRow.Select`
`Selection.Copy Destination:=Sheets("Summary of Variances").Range("A" & lastrow + 2)`
`' copy and paste any highlighted rows in 65535 and 13434879 to first empty row in the Summary sheet`
`End If`
`Next`
