Hey folks,
Got a bit of code running to setup the sheet since the columns keep changing
order at the download. So I got this running to about BP1. Anyway, it's not
picking up the ID. Instead it's picking up OpportunityID. SO column A, B both
populate with OpportunityID, any thoughts?

Dim oFind As Range

Set oFind = Range("1:1").Find("ID")
If Not oFind Is Nothing Then
oFind.Resize(2000, 1).Copy _
Destination:=Worksheets("Raw Data").Range("A1")
End If
Set oFind = Range("1:1").Find("OpportunityID")
If Not oFind Is Nothing Then
oFind.Resize(2000, 1).Copy _
Destination:=Worksheets("Raw Data").Range("B1")
End If