Hi,
I have a couple of problems with my spreadsheet.
1. I have a macro for a new client, it adds it into a main worksheet (Not Inc 8%). I have another worksheet that takes the same information (Inc 8%). Because the new client button inserts a row on the second worksheet it doesn't bring through the information, is there a way around this?
2. As for the new client macro, I need pop up boxes for the following as well in the same code...
Columns:
A - to enter region
B - Start date
E:I - Targets for year 1:5
If this could all pop up one after another with written directions, is that possible?
After this data has been entered would it be possible to sort into alphabetical order for column C
3. I have an 'update' macro which I need to clear the input screen after it has special pasted the data. I can't quite get it to work. - SOLVED
4. I have regions for each of the places on my spreadsheet... what is the best way to group these so I can compare a total of the areas on my 'Comparison' sheet?
Any help would be appreciated!
Thanks
TEST.xlsm
Bookmarks