Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Extraction (Excel 97) | Excel Worksheet Functions | |||
Should I use Do-While loop for my record counter? | Excel Programming | |||
Excel to Access extraction | Excel Programming | |||
data extraction from excel | New Users to Excel | |||
Help with Excel Extraction | New Users to Excel |