Hello,
Is there a way to set up automatic entries in a register for fixed amounts that occur on a Weekly, Bi-Weekly, or Monthly basis.
On the Entries! sheet is the register in columns A thru H that can get filled on next available row from J thru Q based on the time cycle from column R. It seems complicated but I appreciate it if someone has a way to do this.
Thank you very much for your help and support,
Joe
See workbook attached for working version ... I moved some of your columns around in the Entries sheet and added 3 named ranges.
You also need to call it from the workbook open event in the workbook object:
Please Login or Register to view this content.
Hope that helps.Please Login or Register to view this content.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
MatrixMan,
That works perfectly! Thank you so much. This workbook is still developing and hopefully others here can benefit from it.
Best Regards,
Joe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks