I used the macro recording to sort the list first and subtotal them.
It works fine but I also want to transfer(copy) the subtotal of the
worksheet to another worksheet in a specified cell location. I tried a
couple times and it did not work. I just want to know is it doable?
and how? I am very good with excel. I know how to use the macro
recording and I am learning how to write Macro from text book and CD.
I am new to this board and I appreciate your help.