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: 48
Default extracting specific data from a list

I have data in a4:k27.
In Col B I have a flag set (called Active) to track active deliveries.
Not all rows have this flag but 11 rows always have this flag.
How to I extract only those rows with the 'active' flag and show in
cols B:G on Sheet1 only. The end result is that sheet 1 will show 11
active deliveries and various details.
Can it be done with a vlookup statement?

Thanks
Tony

 
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
Extracting Specific Data from one sheet to another. Pulling Data from one sheet to another. Excel Worksheet Functions 1 July 14th 08 10:42 PM
Extracting specific data from a cell Neil Bowen Excel Worksheet Functions 5 October 30th 05 04:33 PM
Pivot Table - Extracting specific data JT Excel Worksheet Functions 1 June 3rd 05 06:05 PM
Extracting specific data from cells AndyUK[_2_] Excel Programming 0 November 11th 04 02:53 PM
Extracting specific data from cells AndyUK Excel Programming 1 November 11th 04 02:32 PM


All times are GMT +1. The time now is 01:24 PM.

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"