If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Automating formatting to include blank rows, formulas etc..

Thread starter caba
Start date Apr 30, 2002

caba

New Member

Apr 30, 2002

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