Excel Macro with Loop to Repeat actions

If you have a repeating series of actions (such as inserting a label 12 times) then you can add a Loop to an Excel macro. Just record you macro as you need then at the start of the repeating step put:

For i = 1 to 12

then your recorded code

Next i

This will make the Excel macro repeat 12 times. Excel training Toronto Mississauga Hamilton Ontario can help you with this and other Excel functions. Note "i" is used here but any word will do.

Bert Twomey
MS Office & Excel training
Toronto, Mississauga, Hamilton Ontario
905-271-1119

Get Excel to fill in the blanks under a name. if you have a name listed once in a column and then a few spaces until the next name you can get excel to copy each name down. Use Control G and use special Go to Blanks, (then all the blanks are selected) then type =A3 (the first blank) and control Enter. Excel will copy each name down as needed.
http://www.actionebiz.com/exceltraining.htm

Bert Twomey
MS Office and Excel Trainer
Toronto, Mississauga, Ontario Canada
905-271-1119