Excel worksheets / Macros

May 26, 2009 at 15:02:08
Specs: Windows Vista
I need help!! Is there a way for me to write a macro that will add up numbers from one sheet and autosum them on to another sheet??

Even if it isn't a macro that can do it, I need to come up with a few different ways to have sheet1 + sheet2 = sheet3 whatever the case may be.

My boss is wanting to have me research excel and macros to eventually have information in quickbooks put into an excel sheet. Whether it be job costing... or time sheets... or man hours.. it is my job to come up with a procedure, and I am lost.



See More: Excel worksheets / Macros

Report •

May 26, 2009 at 20:24:45
You might have to be more specific because you certainly don't need a macro to add values across multiple sheets.

e.g. =Sheet1!A1+Sheet2!C3

Report •

May 27, 2009 at 10:10:00
Ok, I didn's think so. However, my boss is wanting me to research Macros, and eventually "come up" with some form of a macro that will do it for me ( help the autocalculating process along). the formula you posted, is exactly what I have been doing. Any other suggestions? I am a little lost in my task... of research anyway.

Report •

May 27, 2009 at 10:32:49
Once again, I have to ask you to be more specific - or maybe you need a new boss.

Why would (s)he possibly want to use a macro to "help the autocalculating process along" when a simple SUM formula is as automatic as it gets - assuming you have calculation set to Automatic?

If you change an input, the output will change as soon as you hit enter. It doesn't need any "help" to make that happen.

What aren't you telling us?

re: some form of a macro that will do it for me

Do what?

Report •

Related Solutions

May 27, 2009 at 11:10:22
Thank you Thank you Thank you!

So, I am not completely losing my mind.

It doesn't make sense to me either. :\ I just thought I would ask.

I am not an excel "wizz" by any means, however, I am not sure if my boss realizes that you don't need a macro to " autocalculate" or have numbers from one sheet add up numbers on another sheet.

She is wanting me to "research" the capabilities of excel and macros. Then, by December 31st 2009 have a good, solid idea for a proceduer for job costing spreadsheets... man hour spreadsheets... or time card spreadsheets. I think that the autocalculating is the best way to do it. I have just been stressed out.. because she wants me to research everyday.. and I have no idea what she is wanting me to research.

Thanks for your help. wish I could have been more specific, but it isn't even specific to me.

Report •

May 27, 2009 at 12:32:23
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:

Sub AddFormula()
Sheets(3).Range("A1").Formula = "=Sheet1!A1+Sheet2!A1"
End Sub

This will put the actual sum in Sheet3!A2, not the formula.

Sub AddValues()
Sheets(3).Range("A2") = Sheets(1).Range("A1") + Sheets(2).Range("A1")
End Sub

Report •

May 27, 2009 at 15:57:12
by December 31st 2009 have a good, solid idea for a proceduer for job costing spreadsheets... man hour spreadsheets... or time card spreadsheets.

If your boss is looking for you to create these spreadsheets, you might want to look here:


Also a google search on Excel Templates will give you a large collection of free spreadsheets that others have already done and you could possibly modify.

You might also want to see if you can get your boss to spring for an Excel class or two.
Most community colleges offer them for relatively short money.



Report •

May 28, 2009 at 15:02:23
Thank you. I will look into that. I am pretty sure that she wont spring for an excel class. She wanted me to teach myself. I am more of a hands on person. I need someone to show me.

I could always go and take an excel class on my own.

I will definitely look at those spreadsheets, and see what I can get out of it.

Thanks so much for your help.


Report •

Ask Question