Macro search by date and move row

Originally Posted by jj33002

I have attatched file with my question typed at the bottom of the first sheet. It was easier to be looking at it and write the question. There might be an easier way to do it than what I am trying but I just can't even figure it out.
Attachment 9662

Thanks
Josh

Hi Josh,

the question is probably whether you should.
If an amount due from your Cheque account is not paid within the due month it appears red flagged as 'Overdue'. When this is finally paid do you go back to (say) March to note it's payment or do you just let the payment appear in the month of payment?

If it's the latter would you not also allow prepayments to exist in their month of payment?
If you wish to note these figures then two figures 'OverDue total' and 'Prepayment total' could appear in your month summary totals.

I think it is more simple (especially for auditing/checking purposes) to allow transactions to be recorded in their correct chronological order whether they be Cheque or Savings account details.

Hope this helps your thinking.
---

Originally Posted by jj33002

The overdue doesn't bother me. I have that figured out. Whenever I recieve a bill in the mail I file it right then under the month that it is due. If I recieve a bill lets say on March 15 for something that is due on April 2. A week goes by and everything in March is caught up so I decide to pay the one that is due on April 2 but it is only March 22. I was trying to avoid having to move it from the April sheet to March sheet manually. Maybe that makes a little more sense.

to do what you are asking by macro rather than manually, you would either have to enter sufficient details to locate the item, or click on the item in April, trigger the macro, then locate the position for the item to go (it would mostly be the next month, but not guarenteed) which, with your sheetnames would require a table of sheets/months, and then trigger the second part to cause the paste.

It looks much easier to simply Cut and Paste the whole line from Apr to Mar.

but perhaps others have a better idea.

---