Hi, I am new to Excel and I want to create a simple macro to show me the total $ for monthly sales. My spreadsheet has ship date in one column and amount in another, I want a macro to give me the total $ by month. Can I write a macro that will ask for the month that I choose and then give me a total for that month?
Then I want to be able to take that monthly total and use that to calculate a running total for the year. I would also like to be able to sort by customer at some time later. There must be a simple way to do this, but like I said I am new to this stuff.