![]() |
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. |
All times are GMT +1. The time now is 01:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com