Trying to use the command click button. Cell O2 has the invoice number 101,
O3 is 102, O4 is 103 etc. When I put an invoice number in cell E2 (101) and
the invoice name in F2, I would like to click on the button (Submit) and
advance the invoice name to P2. I know I can use the IF formula in Excel but
there is a lot more info that I would like to move with it and all at the
same time.
Thanks