Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1?
When I copy/paste the cell, the sheet reference doesn't change, I get "sheet1!+1, when I copy/paste link I get a reference to the right sheet but loose the "+1", e.g. I get "sheet2!. I need help!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+
YOu'll need to change the Sheet1 to Sheet2 when you copy it to sheet3.
Alternatively, if you have a lot of formulas to change, you could do a global find and replace on that worksheet. "Dany" wrote: how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1? When I copy/paste the cell, the sheet reference doesn't change, I get "sheet1!+1, when I copy/paste link I get a reference to the right sheet but loose the "+1", e.g. I get "sheet2!. I need help!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2
Thx Barb but that's too much work, I'm a lotus 123 user and when you copy
formulas to different sheets the sheet addresses move relatively just like the cell addresses, there's got to be another way, don't you think? "Barb Reinhardt" wrote: YOu'll need to change the Sheet1 to Sheet2 when you copy it to sheet3. Alternatively, if you have a lot of formulas to change, you could do a global find and replace on that worksheet. "Dany" wrote: how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1? When I copy/paste the cell, the sheet reference doesn't change, I get "sheet1!+1, when I copy/paste link I get a reference to the right sheet but loose the "+1", e.g. I get "sheet2!. I need help!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2
I'm not aware of anything in Excel.
"Dany" wrote: Thx Barb but that's too much work, I'm a lotus 123 user and when you copy formulas to different sheets the sheet addresses move relatively just like the cell addresses, there's got to be another way, don't you think? "Barb Reinhardt" wrote: YOu'll need to change the Sheet1 to Sheet2 when you copy it to sheet3. Alternatively, if you have a lot of formulas to change, you could do a global find and replace on that worksheet. "Dany" wrote: how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1? When I copy/paste the cell, the sheet reference doesn't change, I get "sheet1!+1, when I copy/paste link I get a reference to the right sheet but loose the "+1", e.g. I get "sheet2!. I need help!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2
when I tried the find '1 and replace it replaced every 1 (not every '1) in
the cell which messed things up even more. how can I specify better what to replace? "Barb Reinhardt" wrote: I'm not aware of anything in Excel. "Dany" wrote: Thx Barb but that's too much work, I'm a lotus 123 user and when you copy formulas to different sheets the sheet addresses move relatively just like the cell addresses, there's got to be another way, don't you think? "Barb Reinhardt" wrote: YOu'll need to change the Sheet1 to Sheet2 when you copy it to sheet3. Alternatively, if you have a lot of formulas to change, you could do a global find and replace on that worksheet. "Dany" wrote: how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1? When I copy/paste the cell, the sheet reference doesn't change, I get "sheet1!+1, when I copy/paste link I get a reference to the right sheet but loose the "+1", e.g. I get "sheet2!. I need help!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2
How about
Sheet1! with sheet2! Dany wrote: when I tried the find '1 and replace it replaced every 1 (not every '1) in the cell which messed things up even more. how can I specify better what to replace? "Barb Reinhardt" wrote: I'm not aware of anything in Excel. "Dany" wrote: Thx Barb but that's too much work, I'm a lotus 123 user and when you copy formulas to different sheets the sheet addresses move relatively just like the cell addresses, there's got to be another way, don't you think? "Barb Reinhardt" wrote: YOu'll need to change the Sheet1 to Sheet2 when you copy it to sheet3. Alternatively, if you have a lot of formulas to change, you could do a global find and replace on that worksheet. "Dany" wrote: how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1? When I copy/paste the cell, the sheet reference doesn't change, I get "sheet1!+1, when I copy/paste link I get a reference to the right sheet but loose the "+1", e.g. I get "sheet2!. I need help!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1? | Excel Worksheet Functions | |||
Copy result from sheet1 to sheet2 | Excel Discussion (Misc queries) | |||
Referencing sheet1 from sheet2 | Excel Worksheet Functions | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Moving from 1 row sheet1 to sheet2 | Excel Worksheet Functions |