vba - Excel Dynamically Add To If Row Contains Something -
i have excel sheet used customer data entry, such cost of parts, how paid everything, , how paid (cash, credit, or check). here's first page better look: so on first sheet, enter data need, such name, car make, address (the date dynamic =today()). when type "y" in confirm box, data calculated on sheet2 analyze monetary values. here's sheet 2 data can see i'm talking about: pressing "new customer" button runs vba script creates new line on sheet1 customer entry, creates corresponding line on sheet2 new line on sheet1 produce calculated data, , "stores" both sheet1 , sheet2 of previous customer data on sheet3. this leads me question.. sheet2 calculations "cash total", "credit card total", , "check total", need filter through , add (cash + part cost) if paid in cash, (card + part cost) if paid card, , (check + part cost) if paid check. problem cannot figure out how go row row , check whether used cas