I have a big excel file with in column A the names of all employees. A name
is displayed in the following format:

(location) Employee name (Manager name)

I've uploaded a version with only two employees as an example. You can
download it he

http://www.box.net/shared/p9uzf22tha

When you open this file, I want to perform the following actions with a
single macro, if possible:

1- Copy contents cell C1 to A4
2- Select row 4 and set the format to bold
3- Delete rows 1+2+3
4- Delete all rows containing the word "London"
5- The total row currently only shows the values (import from another
program). I want it to display the SUM of the above cells.
6- Now I want all columns which have a total SUM of 0.00 to be deleted

The result should look like this:

http://www.box.net/shared/ybh0hkrejn

Any help on this is greatly appreciated!