| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows but need to refer to same cell in original formula
I need to copy/paste 5 original rows multiple times in worksheet but need
formula to refer back to same static amount in cell k3. How can I do this without having to go to each newly created cell and change it to k3 in formula? That would take hours for me to do. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy rows but need to refer to same cell in original formula
On Apr 4, 10:03*am, addison wrote:
I need to copy/paste 5 original rows multiple times in worksheet but need formula to refer back to same static amount in cell k3. *How can I do this without having to go to each newly created cell and change it to k3 in formula? *That would take hours for me to do. Thanks! If I catch your drift, make K3 an absolute reference: $K$3. . .or am I missing something phenomenological? Pierre |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy rows but need to refer to same cell in original formula
Hi,
Change your reference to an absolute reference.....$K$3 Hope this helps, Gav "addison" wrote: I need to copy/paste 5 original rows multiple times in worksheet but need formula to refer back to same static amount in cell k3. How can I do this without having to go to each newly created cell and change it to k3 in formula? That would take hours for me to do. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy rows but need to refer to same cell in original formula
Make your original $K$3 instead or just K3 and then dragging or pasting will
not alter it from K3 "addison" wrote: I need to copy/paste 5 original rows multiple times in worksheet but need formula to refer back to same static amount in cell k3. How can I do this without having to go to each newly created cell and change it to k3 in formula? That would take hours for me to do. Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy rows but need to refer to same cell in original formula
Thank you all for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In VBA, How to Refer to Cell In Specific Column But Selected Rows? | Excel Discussion (Misc queries) | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy same cell formula in many rows... | Excel Discussion (Misc queries) | |||
| Copy same cell formula in many rows... | Excel Discussion (Misc queries) | |||
| How can I copy many formulas and keep original cell location? | Excel Discussion (Misc queries) | |||
Linear Mode
