|Adding a Helper Column can easily be accomplished with a macro. You just need an easy way to have that macro available all the time. I will now offer you that way...|
If you are not familiar with the personal.xlsm workbook, you should be.
1 - Open a new workbook
2 - Place any commonly used macros in this workbook
3 - Save the workbook as personal.xlsm in your xlstart folder
3 - Hide the workbook
4 - Quit Excel
5 - Excel will ask you if want to save the changes to personal.xlsm (the hide)
6 - Click Save
Any workbook stored in the xlstart folder will automatically open whenever you open Excel. Since personal.xlsm is hidden, you won't even know it's there. However, any macros stored in personal.xlsm will be available for use.
I have a dozen or so icons on my Excel Quick Launch toolbar that have macros from my personal.xlsm workbook assigned to them. All I need to do is click an icon and the macro runs on the currently active workbook. This has saved me thousands of hours of manual work over the years.
I have one macro that adds a Helper Column (nothing more than a copy of an existing column of data) and also some Conditional Formatting. This helps me keep track of which pieces of data I have updated. When I change a cell in the original data column, it no longer matches the Helper Column value and turns Yellow. After I have completed all of the required updates, I click the same Icon again and the Helper Column and Conditional Formatting rules are deleted.
All you need is a macro that knows (or is told via an InputBox) where to place the Helper Column(s) and what formula(s) to fill it (them) with.
(When you want to add a new macro to personal.xlsm, just unhide it, add your macro, and hide it again. When you quit Excel, you'll be asked if you want to Save it.)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03