| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
adding worksheets together
I have two worksheets with the same column config. I would like to add the 2
together and wind up with a master(and be add others to it later) as well as the 2 orginals.................Gary |
|
#2
|
|||
|
|||
|
Something like this? Cell A1 on sheet 3 would have the formula
=Sheet1!A1+Sheet2!A1 The copy the formula to all other cells where you want "Gary" wrote: I have two worksheets with the same column config. I would like to add the 2 together and wind up with a master(and be add others to it later) as well as the 2 orginals.................Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding values from previous worksheets | Excel Worksheet Functions | |||
| adding worksheets with conditions | Excel Worksheet Functions | |||
| adding values across worksheets in a spreadsheet | Excel Worksheet Functions | |||
| Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
