I have an access query imported into a spreadsheet. However this data needs to be inserted every month. Therefore I want to automate the sorting of the spreadsheet by a column, then resort the whole spreadsheet again using three columns. Then for every change in a particular area I need three rows to be inserted and certain statistical formulas to be entered. How would I start this off using VBA. I could probably do some of it using macros and named ranges, but how do I insert 3 blank rows for every change in an area.
Regards.
Carl J Barrett
Regards.
Carl J Barrett