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

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

I have though of that. However, the problem is is if those two Cell's
don't match the other two. Then i need it to continue going down until
it finds the right one. My main question i guess is can you use for
loops and hold varibles. Because pretty much i need to create something
that will Say this spreedsheet is Lane #1 and New Step #1 if customer is
this then add one if not go to New Step #2. If get's to Step #19 Then
start over and go to Step #1 until you find the correct location to add
one. So, once it's all done ill be able to tell how many customer are
Lane #4 and Have New Step #2. (There's 156 Customers).


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

then perhaps a sumproduct formula will help???
=sumproduct((a2:a22="lane #1")*(b2:b22="step $19"))

--
Don Guillett
SalesAid Software

"nempo" wrote in
message ...

I have though of that. However, the problem is is if those two Cell's
don't match the other two. Then i need it to continue going down until
it finds the right one. My main question i guess is can you use for
loops and hold varibles. Because pretty much i need to create something
that will Say this spreedsheet is Lane #1 and New Step #1 if customer is
this then add one if not go to New Step #2. If get's to Step #19 Then
start over and go to Step #1 until you find the correct location to add
one. So, once it's all done ill be able to tell how many customer are
Lane #4 and Have New Step #2. (There's 156 Customers).


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