This is my first time using this so forgive me if it is not clear enough.
My Spreadsheet has formulas in Columns : "Amount Due", "# Due", "Paid", and "Balance" When I put the "Due" figure in "Returned" it puts the "amount Due" figure in "Pad" and the "Balance" figure goes away, I then enter the date and payment method. What I would like to happen is that when I enter the figure in "Returned" and the "Balance" is cleared I would like to offset to "Date" and enter todays date, and then offset to "Method" and enter "Cash".
I have been using "Intersect" with " Range" and "Target.Row" and the column # for the "Balance" column but no luck.
Thanks for your help
My Spreadsheet has formulas in Columns : "Amount Due", "# Due", "Paid", and "Balance" When I put the "Due" figure in "Returned" it puts the "amount Due" figure in "Pad" and the "Balance" figure goes away, I then enter the date and payment method. What I would like to happen is that when I enter the figure in "Returned" and the "Balance" is cleared I would like to offset to "Date" and enter todays date, and then offset to "Method" and enter "Cash".
I have been using "Intersect" with " Range" and "Target.Row" and the column # for the "Balance" column but no luck.
Thanks for your help