View Single Post
 
Old 06-02-2015, 02:47 PM
llhail llhail is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2015
Posts: 1
llhail is on a distinguished road
Default large workbook needs restarted every month with deletions and resort without losing formulas

I have a very large workbook that has columns with formulas and macros feeding other forms. There are more than 600 rows and 80 columns.
During the month it's fast and easy to use and provides valuable information. Unfortunately, the form must be "restarted" every month.

The rows require some deletion and additions and sorting alphabetically with each new month.
I have created a test form and tried a few things but every time I mess up the formulas or macros and have to undo everything.
Can anyone help?
Reply With Quote