hey Guys
I am having issues with my code. Originally (see original code) I would loop through all sheets and combine data in to one. This worked great. Only 1 sheet had headers (data spill).
'Original code
For i = 2 To Sheets.Count
Set xRg = Sheets(1).UsedRange
If i > 2 Then...