KlayontKress
Board Regular
- Joined
- Jan 20, 2016
- Messages
- 67
- Office Version
- 2016
- Platform
- Windows
To all,
I'm looking for a macro to allow a user to first select the columns that they need the values added together and then run a macro sum up the values in the rows for those columns and copy those sums into the respective rows in a different column (column D).
This worksheet has numeric and non-numeric data, and I need the macro to only add and move the numeric data. The good news is that the numeric data starts in row 9, so if needed, we could exclude rows 1-8. from being moved.
For all practical purposes, there is never more than 1000 rows of data, so if it's easier to limit this to rows 9-1000 when the columns are selected. that would be an acceptable solution. The key thing is the person being able to first select the columns to be added and having a macro add and move the values to another column.
Any help is greatly appreciated.
I'm looking for a macro to allow a user to first select the columns that they need the values added together and then run a macro sum up the values in the rows for those columns and copy those sums into the respective rows in a different column (column D).
This worksheet has numeric and non-numeric data, and I need the macro to only add and move the numeric data. The good news is that the numeric data starts in row 9, so if needed, we could exclude rows 1-8. from being moved.
For all practical purposes, there is never more than 1000 rows of data, so if it's easier to limit this to rows 9-1000 when the columns are selected. that would be an acceptable solution. The key thing is the person being able to first select the columns to be added and having a macro add and move the values to another column.
Any help is greatly appreciated.