This is what I have so far but it does not work. Since I have both workbooks open, I get a message about opening the workbook again.
Sub ReviewData()
Dim r As Range, c As Range, cfind As Range
Dim wbData As Workbook
Dim wbDes As Workbook
Dim shData As Worksheet
Dim shDes As Worksheet
Set wbData = Workbooks.Open("FCRT Request Form 0723.xlsm")
Set wbDes = Workbooks.Open("Flood Review DB3.xlsm")
Set shData = wbData.Worksheets("Review Data")
Set shDes = wbDes.Worksheets("Data")
With shDes
Set r = Range(.Range("A2"), .Range("A2").End(xlDown))
For Each c In r
Dim x
x = c.Value
With shData.Columns("A:A")
Set cfind = .Cells.Find(what:=x, lookat:=xlWhole)
If Not cfind Is Nothing Then
Dim rdata As Range
Set rdata = Range(.Cells(cfind.Row, "B"), .Cells(cfind.Row, "AI"))
rdata.Copy
End If
End With
.Cells(c.Row, "U").PasteSpecial
Next c
End With
End Sub
Bookmarks