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: 143
Default Is this imposible for VBA to perform?

I have several variables. First I have a named range "notelist", which is
column B or 2. I want to pick up certain data in the 'offset' columns 12, 17,
18, 19, and 23 if certain conditions are met in columns 2 , 5 and 22. I was
trying to use offset(0,12) etc.

For example, the first criteria is in column 22 if it is "FO" or 'FR" then
go to offset (0,2) if it has a number in the range of 600-606 go to offset(0,
5) if it has a number in the range of 0-150 go to offset(0,17), I need it to
count how many, got to offset(0,18) count how many and offset (0,19) and
count how many have numbers in each column 1, the remainder will have 0 and
I don't want them. The next thing I need it to do is go to column 12 if it
has a letter "X" count how many rows have X's. Finally go to column 23 and
how many are not blank, or how many have letters. I tried to put A in my
code or "" but couldn't get any to work. Any ideas?

I have to repeat this several times according to columns 2 and 5. I have
ranges in both that I have to sepeate. For example I have a range 300-360 in
offset(0,2) with a range in offset(0,5) of 151-159. This is repeated several
times with different ranges. I tried use Case 600-606 and then I was going to
change it for the other ranges.

I would put the code I wrote and am trying to run but I think it is pretty
bad. I am a novice and have been battling this for a couple of days.

Any help would be appreciated!
Marie


 
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
I cannot perform this function PLEASE HELP! Sunny Excel Worksheet Functions 5 March 10th 08 08:20 PM
perform 1 function, stop, perform different function nastech Excel Discussion (Misc queries) 0 August 22nd 06 12:21 PM
How do I perform a concatenate? Alfredo Excel Worksheet Functions 2 April 25th 06 08:27 PM
How to perform two actions ? morph000 Excel Worksheet Functions 5 January 22nd 06 02:13 AM
How can perform a summation? Leebo Excel Worksheet Functions 5 August 23rd 05 04:38 PM


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