|re: .She is wanting me to "research" the capabilities of excel and macros|
Let's put it this way...
Macros are extremely powerful and it makes sense to "research" the capabilities. One very basic use of macros is indeed to "automate" certain things.
For example, in my job I need to write very similiar formula many, many times in literally hundreds of spreadsheets. Simple formula, like =C3 or =C3*.43. These formulae will always be in the same row as the value in column C.
I automated this process by writing some simple macros and adding them to my right-click contents menu. Now all I have to is right-click a cell, such as D45, select Equals and it will put =C45 in the cell. If I don't want Equals, I choose Partial, a dialog box pops up and I enter a value, such as 43. The code then places =C45*.43 in the cell. These are just 2 of the 6 or so macros that I use on a daily basis so I don't have to type the same formulae over and over again.
On the far end of the scale I have a series of rather complicated Macros that I use for running a sports pool. All I have to do is put a 1 in the cell next to a winning team's name and the code calculates the correct points for everyone who has choosen that team, updates the database and creates a scoresheet ready for printing.
In your case, it may indeed be helpful to use macros in your workbook, especially if you find yourself repeating the same tasks over and over again, but you would need to find out from your boss what he is looking for.
If your boss really wants a macro, here's 2:
This one will put a formula in cell Sheet3!A1 to Sum Sheet1!A1 and Sheet2!A1:
Sheets(3).Range("A1").Formula = "=Sheet1!A1+Sheet2!A1"
This will put the actual sum in Sheet3!A2, not the formula.
Sheets(3).Range("A2") = Sheets(1).Range("A1") + Sheets(2).Range("A1")