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: 64
Default Linking to separate worksheet with 2 criteria

I have a sales forecast with different sales people and a criteria if the
sale is scheduled for FY08. What I would like to do on another worksheet
within the workbook is 2 fold.
1. If the potential client is FY08 (Col T) and Belongs to "SalesPerson"
(Col E) Pull the client name and place it into separate Worksheet in Column
A.
2. If the Account is pulled, Pull the $ value (Col P) into the same new
worksheet in Column B.
Please Help
 
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
criteria to filter and extract row data into separate worksheet karenc Excel Worksheet Functions 1 December 16th 08 03:25 AM
Pull info from separate worksheet based on given criteria Chas Excel Discussion (Misc queries) 10 September 26th 08 08:48 PM
Summing totals on separate worksheet based on 2 criteria Cheese_whiz Excel Discussion (Misc queries) 4 January 6th 08 10:34 PM
Linking to a worksheet in a separate workbook AcesUp Excel Discussion (Misc queries) 3 June 3rd 06 02:52 PM
Separate Worksheet Linking JaeP Excel Discussion (Misc queries) 0 May 17th 05 04:52 PM


All times are GMT +1. The time now is 12:29 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"