Hello I’m new to macros and have the basic principle of how to use them, but code writing is not a strong point for me. What I would like to do is create a button in excel so when I open my sheet to pay the next invoice I can click this button and the totals in column “G”, copy over to column “I” but when they copy from “G” to “I” the totals keep adding up in “I” each time the button is clicked. Also after the totals from "G" are copied and added up in "I" I need the totals in "G" to go back to 0 or be blank again.
I trying once and a whole bunch of "0's" showed up in all of the other blank spaces...all blanks cells I need to show as blank and not "0's" as well.
I hope this makes sense…can anyone help?
I trying once and a whole bunch of "0's" showed up in all of the other blank spaces...all blanks cells I need to show as blank and not "0's" as well.
I hope this makes sense…can anyone help?