I have a WS where there are cells/fields where specific Items are selected. I'm looking for a macro that recognizes a mouse "click" as a "P" with Wingdings2 so it comes out as a "check", then if selected, moves the value into a specific list. Looking at the WS will clearly show what I'm looking for. So the macro does two things, it clicks a selection (as a checkmark) and it moves selected values only, into their own column where they are totalled/summed.
Thank you in advance.