Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special???
I realize this may not be a programming question, but... I've got a workbook with several sheets. On sheet 2, I have several columns with the following formulas: =Sheet1!C$674 =Sheet1!C$684 =Sheet1!C$694 ... etc I'm wanting to copy these to another location. They are in Column D (sheet2) currently, and I'm wanting to copy them to another location on sheet2; Column C. However whenever I copy them, the formulas change to: =Sheet1!B$674 =Sheet1!B$684 =Sheet1!B$694 ... etc Is there anyway to get them to stay the same?!? Thanks in advance... DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=379440 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
How do I capture user paste action and convert to Paste Special | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |