R
rmolitor
Hey all, long time reader, first time poster.
I've written an statistical program for totaling results for m
wrestling team/individuals. I use an array to sort by name to detai
that persons stats.
I originally enter the data using a Macro to move the data from a
entry form to the data sheet. When hitting "submit" after entering th
stats, I have to add a row to the data sheet so the Macro has a place t
put the data entered. That works fine.
Problem happens in the array when the add row occurs... my formula als
gets moved up by one row. I want the data to remain the same.
Let me try explaining with the formula. First line is what the arra
looks like before hitting submit. Second line is what happens afte
the data has been entered. I don't know how to LOCK this in.
=SUM(((Wrestlers_Statistics!$B$2:$B$64998)=$A$3)*(Wrestlers_Statistics!$M$2:$M$64998))
=SUM(((Wrestlers_Statistics!$B$3:$B$64998)=$A$3)*(Wrestlers_Statistics!$M$3:$M$64998))
I've also tried using the =SUBTOTAL function, as well as Defining
Name, and oddly enough both do the SAME thing. I'm out of ideas.
I can get all of my functions to work if I tweak the cell back afte
the submit Macro changes the cell call, but what do I do to KEEP i
there?
I'd be happy to email anyone a copy of my program... I just really nee
help.
mailto:[email protected]
Thanks
I've written an statistical program for totaling results for m
wrestling team/individuals. I use an array to sort by name to detai
that persons stats.
I originally enter the data using a Macro to move the data from a
entry form to the data sheet. When hitting "submit" after entering th
stats, I have to add a row to the data sheet so the Macro has a place t
put the data entered. That works fine.
Problem happens in the array when the add row occurs... my formula als
gets moved up by one row. I want the data to remain the same.
Let me try explaining with the formula. First line is what the arra
looks like before hitting submit. Second line is what happens afte
the data has been entered. I don't know how to LOCK this in.
=SUM(((Wrestlers_Statistics!$B$2:$B$64998)=$A$3)*(Wrestlers_Statistics!$M$2:$M$64998))
=SUM(((Wrestlers_Statistics!$B$3:$B$64998)=$A$3)*(Wrestlers_Statistics!$M$3:$M$64998))
I've also tried using the =SUBTOTAL function, as well as Defining
Name, and oddly enough both do the SAME thing. I'm out of ideas.
I can get all of my functions to work if I tweak the cell back afte
the submit Macro changes the cell call, but what do I do to KEEP i
there?
I'd be happy to email anyone a copy of my program... I just really nee
help.
mailto:[email protected]
Thanks