LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Extraction (Excel 97) Phendrena Excel Worksheet Functions 6 February 14th 08 09:49 AM
Should I use Do-While loop for my record counter? excelnut1954 Excel Programming 0 March 24th 06 09:25 PM
Excel to Access extraction [email protected] Excel Programming 1 February 8th 06 05:52 PM
data extraction from excel claw New Users to Excel 2 January 23rd 06 07:57 PM
Help with Excel Extraction YvonneSmythe New Users to Excel 1 August 29th 05 09:51 PM


All times are GMT +1. The time now is 06:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"