have you tries using find and findnext

--
Don Guillett
SalesAid Software

"nempo" wrote in
message ...

Ok. I'm working with a customer who has two spreadsheets. She's trying
to count the number of people based on there Lane and New Step.
She's has a section called Lane (which can be numbers from 1-6) and New
Step (which can be numbers from 1-19). Now the code is going to have to
check the selected cell's for the customer and then match them to the
other spreedsheet's correct lane and New step. So, when it's done i
cant tell how many customer were a Lane #1 + New step #1 or Lane #1 +
New step #2. Does anyone have any idea's on how i would set this up. I
though about IF statements, but i would need a for loop and i don't
think excel will enjoy my 3 page coding in Excel per Cell. Is there any
other way to do this?


--
nempo
------------------------------------------------------------------------
nempo's Profile:
http://www.excelforum.com/member.php...o&userid=28401
View this thread: http://www.excelforum.com/showthread...hreadid=563474