Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Formula But Keep 1 Common Cell
I hope someone can help?
Trying to set up a rate sheet but trying to keep 1 common cell. Example- cell c13 =sum c12+g3 c14 =sum c13+g3 c15 =sum c14+g3 c16 =sum c15+g3 repeated for onother 250 rows Tried everthing that I can And read this info centre |
#2
|
|||
|
|||
Hi
in C13 enter =C12+$G$13 -- Regards Frank Kabel Frankfurt, Germany Towmech wrote: I hope someone can help? Trying to set up a rate sheet but trying to keep 1 common cell. Example- cell c13 =sum c12+g3 c14 =sum c13+g3 c15 =sum c14+g3 c16 =sum c15+g3 repeated for onother 250 rows Tried everthing that I can And read this info centre |
#3
|
|||
|
|||
=sum(C12,$G$3)
Vaya con Dios, Chuck, CABGx3 "Towmech" wrote in message ... I hope someone can help? Trying to set up a rate sheet but trying to keep 1 common cell. Example- cell c13 =sum c12+g3 c14 =sum c13+g3 c15 =sum c14+g3 c16 =sum c15+g3 repeated for onother 250 rows Tried everthing that I can And read this info centre |
#4
|
|||
|
|||
Thanks for the very quick reply worked great.
Great to have people like you to help out. "Frank Kabel" wrote: Hi in C13 enter =C12+$G$13 -- Regards Frank Kabel Frankfurt, Germany Towmech wrote: I hope someone can help? Trying to set up a rate sheet but trying to keep 1 common cell. Example- cell c13 =sum c12+g3 c14 =sum c13+g3 c15 =sum c14+g3 c16 =sum c15+g3 repeated for onother 250 rows Tried everthing that I can And read this info centre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) |