I need help with a satement that will verify the date in one
row(sheet1.A3) and a second value(sheet1.c3) are equal to set values.
If they are both equal i need to start a running total. then display
that total on a diffrent sheet.

I understand the basics of programing, just not the language that excel
uses. I was going to have the user enter the total number of
itterations.

I need to know how to increase the row using the loop variable. and I
need to know how to pass data from workbook, to VBA, and back.

So in excel say sheet1.A1 is the total number of times to do the loop.
stuff in { } is what i need help with.
the IF is writen in what Excel uses for an if statement which i believe
is not what the VBA will use.

num = 0
For loopx = 3 to Sheet1.A1
If((AND(Sheet1!A3{this needs to increase with the count of loopx} =
dateiamlookingfor, Sheet1!C3{this needs to increase with the count of
loopx} = valueiamlookingfor)),num = num + E3{this needs to increase
with the count of loopx}
next loopx
{Print num to a cell on sheet2}

I know its alot to ask, my brain is just dead, and i do not know much
about excel...yet

Thanks


--
kixelsid
------------------------------------------------------------------------
kixelsid's Profile: http://www.excelforum.com/member.php...o&userid=31901
View this thread: http://www.excelforum.com/showthread...hreadid=516301