Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copying cells from other worksheets
How do I copy individual cells into one worksheet from other (more than one)
worksheets into a formula and then copy the remainder of the column to match each corresponding cell like the first one copied so that I am copying same cell areas from each worksheet when I drag and copy that one formula? Not sure if I explained this correctly. For example there are four lodging properties (or worksheets with the same template) and one resort worksheet. So I am copying a1 from each of the four worksheets in a simple addition formula that I need to have duplicate for b1, c1, and so forth across the resort worksheet column without having to go to each worksheet for each formula with my mouse. Hope that explains it. |
#2
|
|||
|
|||
bob
To SUM all A1 cells from each sheet enter on the Resort sheet =SUM(sheet1:sheet4!A1) Drag/copy across to increment B1, C1 If sheets have unique names that would not fit the above example, insert a dummy sheet after the Resort sheet(sheet at beginning) and name it First. Insert a dummy sheet at end and name it Last. Formula would now be =SUM(First:Last!A1) Gord Dibben Excel MVP On Sun, 6 Feb 2005 18:07:02 -0800, yesbob wrote: How do I copy individual cells into one worksheet from other (more than one) worksheets into a formula and then copy the remainder of the column to match each corresponding cell like the first one copied so that I am copying same cell areas from each worksheet when I drag and copy that one formula? Not sure if I explained this correctly. For example there are four lodging properties (or worksheets with the same template) and one resort worksheet. So I am copying a1 from each of the four worksheets in a simple addition formula that I need to have duplicate for b1, c1, and so forth across the resort worksheet column without having to go to each worksheet for each formula with my mouse. Hope that explains it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying ranges of data between worksheets | Excel Worksheet Functions | |||
How do I unlink cells in different worksheets when there are no a. | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
sum of different cells in different worksheets??? | Excel Worksheet Functions |