VBA Loop Excel Record Extraction
I am looking for a vba loop that does the following.
First it looks at a cell(A5) in an excel sheet (sheet name = "Report")
then goes to another sheet(sheet name="Raw Data") and looks in the
first column(A:A) for the value in Report'!A5, Each time it finds a
match (there are going to be multiple else vlookup would have been a
viable option) it cuts and pastes a range (Raw Data!B:F) from that row
and pastes it into a range ("Report!A:E"). Any help would be greatly
appreciated. Thanks in advance.
|