![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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? |
#2
|
|||
|
|||
![]()
I can certainly relate to the issues you are having. What exactly is it that you need help with though? Do you need help knowing what you can and cant do when formatting a worksheet? Do you need help with understanding what the code is doing? When you say formulas and macros get messed up it sounds like there needs to be a macro to "Reset" the worksheet. To do this you need to post a sample book with some of the data and the desired result so we can write something up for you.
Thanks |
![]() |
Tags |
sorting deleting macros |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
Probably a Noob-Question: How to 'resort' a spreadsheet? | roderh | Excel | 10 | 05-09-2014 08:18 AM |
![]() |
theta30 | Word | 6 | 03-20-2014 03:57 PM |
Macro to format additions deletions when Comparing Files | Alphacsulb | Word VBA | 0 | 08-19-2013 03:03 PM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |