I’ve booked about three hundred hours plus of work in March. This is not by choice, it’s just the nature of the business, but I am always looking for ways to be more efficient. As an auditor, there are a lot of menial tasks that can be eliminated with macros in excel files. We are interested in totals and it’s a pain to have to copy a set of numbers into another worksheet and sum them up to get the number you need. Typically when you highlight a set of numbers the total will appear on the bottom left hand corner. I wanted to be able to copy that total directly and paste it in a separate spreadsheet.
Refer to the below five step process:
Thanks so much, have been looking for this for a while. I have one problem though…sometimes I want to select items after a filter is in place, this tip selects everything that is 'hidden' by the filter as well as viewable. Is there any way to fix this?
Is there anyway to get this macro to work across spreadsheets and for the macro to be saved for all excel spreadsheets on the computer (not just the particular spreadsheet)?Thanks.