ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Loop Excel Record Extraction (https://www.excelbanter.com/excel-programming/365704-vba-loop-excel-record-extraction.html)

JI[_2_]

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