|
Dave
This is just a suggestion. Most actions that a Macro does can be handled with a formula like an "If" statement. Macros take up a lot of memory and space. Another idea if you cannot solve your problem is to create several spreadsheets and link them although you may not have enough memory for that either. Or instead of 1200 rows on your spreadsheet, create tabs for each month, i.e., and do a formula to refer to the "balance" i.e., on the previous month. This way what is on the screen is just say the current month. I did accumulative attendance for school districts this way. I love Excel and love to show people all it can do. I taught classes for many years in Excel, Word and PowerPoint. I had the very first version of Excel a lot of years ago. The geek that installed it for me was Bill Gates' college roommate and he called Bill for help during the installation. Bill was pretty much a nobody then.
Happy trails.........................
|