Code to Get Value from Form and Add to Total

[TFiske]

Hi all,

Very new to VBA.

We order large amounts of annual flowers for a city beautification program every year. The orders come in from citizens and groups that have adopted a flower planter around the city. I am trying to devise a faster way of totaling up the flower orders and keeping track of what each group ordered.

In the attached sample, the user would enter how many flats of each variety of flower by color in the table in "Flower Order Entry."

The Enter button on the "Flower Order Entry" would run a macro that:

1) grabs the values entered into the table and the group name from "Flower Order Entry" and basically copy/paste to the first available row in the "Total Flower Order" tab (Columns A:V).
2) adds up all the orders by flower type and color in AA4:AS26 of the "Total Flower Order" tab. The Sample sheet has expected values.

This is just an idea of how to do this. If anyone has another suggestion of how to build this, I'd love to hear it. Thanks!!