How to make Multiple Sheet Changes in Excel so that a change made on one sheet happens on all sheets
In this segment we will show you how to make multiple sheet changes in excel.
In this example we have four sheets which represent different cities of the world. Each one has got a Salesman summary report, so this is the London report with the individual Sales people, the New York report and you’ll see that this is all exactly the same on each sheet. Paris and Johannesburg.
What happens if you’d like to change this, lets say you’ve got the company name wrong, how can you change it so that it happens to all of these sheets at the same time
If you are comfortable that the sections are the same, let’s say London you can see the first four rows look very similar to New York’s first four rows, what you can do is
Now what you can now do, whatever gets done on the one sheet gets done on all the sheets. So for example
While the tabs are highlighted white, anything you do here will happen to all four sheets. So let’s say we want to be more politically correct,
Although this is a great feature it does have a risk. It’s very easy to work on this and then forget that you’ve highlighted all these tabs. So let us say that we decide that Johannesburg is not that well known
Because what you do to one you do to all. So it’s very important to realize that when you are finished making the changes that belong to all the sheets
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”– Absa Capital