Added to Library on 20 Jul 2008
Length: 8 mins
View Tutorial Movie
Download File Used |
In this tutorial you will learn two techniques for carrying out the same task on two or more worksheets at the same time. The first technique is very simply and anyone who can click a mouse will be able to master it in less time that it takes me to demo it (about 4 mins).
The second technique shows you how to do the same thing using VBA. Now dont get scared by the mention of VBA I am going to write just 3 lines of code and spend 4 mins explaining them to you. In fact I would go as far as to say that if you have never used VBA in the past you will be comfortable with what is shown in this tutorial.
If you find yourself doing repetitive tasks on more than one sheet then this tutorial will save you 75% of your time.
Enjoy.
Clayton.
P.S This tutorial was produced at the request of a Tutorial Library member dont forget you can ask for tutorials to be made to help you.
|
|
Related Tutorials:
Using Macros to Save You Time
|
Feedback for this tutorial:
"I have worked on multiple worksheets before but not with vba.
Wow - what a powerful tool for multiple sheet manipulation.
Had a play with code by copying the whole Macro2 and changed the name to "InsertColumnA". I then replaced the word "Delete" with "Insert" so the code was now
For icount = 1 To ActiveWorkbook.Sheets.Count
ActiveWorkbook.Sheets(icount).Select
Columns("A:A").Select
Selection.Insert Shift:=xlToLeft
Next icount
And what do you know, a new column A in each of the worksheets.... Guess what you change to either insert or delete "Rows"?
Fantastic.. another thumbs up for Clayton"
|
|
