| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a formula from original cell to mutilpe cells?
I have a formula that I need to copy to cell below it. However, the first
code of the formula needs to remain the same value. EX: =((E5*'GSP Guest Counts'!B5)+'GSP Guest Counts'!B5) The B5 in the next cell should be B6 and E5 stays the same. A manager deleted all the formula's and I figured out the formula, however can't get in copied to other locations. -- Lisa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying a formula from original cell to mutilpe cells?
Try the below
=(($E$5*'GSP Guest Counts'!$B5)+'GSP Guest Counts'!$B5) Below are the different reference styles. A1 Relative referencing. Both column and row will change if you copy or drag the formula. $A1 The column reference is fixed and will not change A$1 The row reference is fixed and will not change. $A$1 Column and row reference are fixed. If this post helps click Yes --------------- Jacob Skaria "Lisa" wrote: I have a formula that I need to copy to cell below it. However, the first code of the formula needs to remain the same value. EX: =((E5*'GSP Guest Counts'!B5)+'GSP Guest Counts'!B5) The B5 in the next cell should be B6 and E5 stays the same. A manager deleted all the formula's and I figured out the formula, however can't get in copied to other locations. -- Lisa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying a formula from original cell to mutilpe cells?
So if I want to have the E5 reference to stay fixed in all cells I would put
the $E$5 and that will keep that cell in each string, no matter the data after it. -- Lisa "Jacob Skaria" wrote: Try the below =(($E$5*'GSP Guest Counts'!$B5)+'GSP Guest Counts'!$B5) Below are the different reference styles. A1 Relative referencing. Both column and row will change if you copy or drag the formula. $A1 The column reference is fixed and will not change A$1 The row reference is fixed and will not change. $A$1 Column and row reference are fixed. If this post helps click Yes --------------- Jacob Skaria "Lisa" wrote: I have a formula that I need to copy to cell below it. However, the first code of the formula needs to remain the same value. EX: =((E5*'GSP Guest Counts'!B5)+'GSP Guest Counts'!B5) The B5 in the next cell should be B6 and E5 stays the same. A manager deleted all the formula's and I figured out the formula, however can't get in copied to other locations. -- Lisa |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying a formula from original cell to mutilpe cells?
Thats right..
If this post helps click Yes --------------- Jacob Skaria "Lisa" wrote: So if I want to have the E5 reference to stay fixed in all cells I would put the $E$5 and that will keep that cell in each string, no matter the data after it. -- Lisa "Jacob Skaria" wrote: Try the below =(($E$5*'GSP Guest Counts'!$B5)+'GSP Guest Counts'!$B5) Below are the different reference styles. A1 Relative referencing. Both column and row will change if you copy or drag the formula. $A1 The column reference is fixed and will not change A$1 The row reference is fixed and will not change. $A$1 Column and row reference are fixed. If this post helps click Yes --------------- Jacob Skaria "Lisa" wrote: I have a formula that I need to copy to cell below it. However, the first code of the formula needs to remain the same value. EX: =((E5*'GSP Guest Counts'!B5)+'GSP Guest Counts'!B5) The B5 in the next cell should be B6 and E5 stays the same. A manager deleted all the formula's and I figured out the formula, however can't get in copied to other locations. -- Lisa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep original cells embedded in merged cell | Excel Discussion (Misc queries) | |||
| Excel not copying formula reference to original workbook | Excel Worksheet Functions | |||
| multiplying the same cell by different cells and copying formula | Excel Worksheet Functions | |||
| Losing Original Cell Format when pasting in cells | Excel Discussion (Misc queries) | |||
| Mutilpe sheet , multiple formula help please. | Excel Worksheet Functions | |||
Linear Mode
