Who's the excel formula wizard?

[Leatherneck]

I have a 3 tab workbook where I need what I type in the first and second worksheet to automatically populate the 3rd worksheet. I am having a tough time figuring out the formula.

[TinyTim]

Try this if you are trying to add numbers (or multiply, then replace the + with a *).... =SUM(Sheet1!B2+Sheet2!B2)

Or to do it with a concantenate (sp?) - where you want to join characters and not numbers - try:

=Sheet1!B3&Sheet2!B3

Where Sheet1 is the name of your worksheet (remember to try and avoid spaces in the names, use an underscor _ instead) and B3 is the cell you wish to use in the formula.

[purecomedy]

Another option is to write some VBA macros. I think there is an event called OnMove or something to that extent that could keep that 3rd sheet very up to date. As soon as you update a cell and press Enter to save the data in that cell you could trigger the update to the 3rd sheet.

Note: If there is a huge amount of data it could introduce a slight pause into the sheet (ie. some negative performance effect).