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.

See answer elsewhere.

Pete

On Nov 23, 9:19 pm, helen wheels wrote:
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.