Data Form, Countif and Macro

[helen wheels]

I have a spreadsheet where I've used a form to enter a customer's
detail and the price of the ticket. I've got a macro that adds that
information to a worksheet.

I've then got a countif formula with absolute cell references to count
the number of people wanting which starter, starter 1, starter 2 or
starter 3.

The problem I have is that the macros is adding the data to the top of
the data in the worksheet by inserting a new row between the existing
data and below the heading, which means the countif isn't seeing the
newest data added to the sheet.

Any help would be greatly received.

Many thanks.

 

[Pete_UK]

Maybe you should change your COUNTIF formula so that it uses the full
column - instead of:

=COUNTIF(A$2:A$50,2)

change it to:

=COUNTIF($A:$A,2)

Hope this helps.

Pete

 

[helen wheels]

Pete

Thank you so much for your help - it seems blindlingly obvious now!

Much appreciated - have a good weekend.


Helen

 

[Pete_UK]

You're welcome, Helen - thanks for feeding back.

Pete