LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default offset macro based on multiple criteria

Look in the vba help index for FIND and combine with IF and OFFSET

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"davemon" wrote in message
...
A little help needed from the gurus.........
I need the following to happen:
If in any row, the value in column 15 equals "trade" and the value in
column
17 equals either "r" or "w", then offset(0,2).select.

Thanks in advance
Dave


 
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
Taaly all based on multiple criteria Teethless mama Excel Discussion (Misc queries) 0 January 19th 07 08:36 PM
Taaly all based on multiple criteria Andi Excel Discussion (Misc queries) 1 January 19th 07 08:33 PM
sum based on multiple criteria Todd Excel Worksheet Functions 3 May 5th 06 10:06 PM
Summary Based on Multiple Criteria Phillycheese5 Excel Worksheet Functions 2 January 6th 06 03:06 PM
Multiple Sum, based on criteria Andy the yeti Excel Worksheet Functions 4 December 22nd 05 02:32 PM


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