Nov 23 2020 11:40 AM
I have an excel file with more then 2000 orders.
When an order is finished, i click on the selection box at the end of the row,
I would like to see the total amount that the orders have.
The formula i already have, but i would like to know if a can copy the selection box so that it will automatic link with the right cell, or do i have to manualy link every selection box to the right cell?
I hope i've made myself clear, english is not my native language.
Thank you
Nov 23 2020 11:59 AM
You have hidden column D which is a part of your calculation, making it hard to see exactly what you're doing.
My own reaction to your question is to wonder WHY you are bothering with a selection box in the first place. Why not just enter a "Y" or some other single key stroke? Granted the selection box is fun, but it seems like overkill for this particular application.