Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Link Problem
I have a workbook containing several worksheet. The first sheet is named Production Output and contains totals which I require in another worksheet. The details in the Production Output sheet are as follows: cell D21 contains the value £22,756 Cell F21 contains the value £32,988 Cell H21 contains the value £53,537 Cell J21 contains the value £58, 350 I was to copy these values into another worksheet starting in cell B3 and then continuing down in cells B4, B5, B6 etc The formula in B3 is therefore =ProductionOutput!D$21 and the formula in B4 is =ProductionOutput!F$21. I now select cell B3 and B4 and want to copy this formula down cells B5 onwards but when I do this it replicates the formula in B3 and B4 and does not increment it. I have also tried putting the answers along row 3 rather than down column B but the following answers appear: in cell B3 I have the formula =ProductionOutput!D$21 in cell C3 I have the formula =ProductionOutput!F$21 When I copy this along row 3, cell D3 contains the formula ProductionOutput!F$21 and then cell E3 contains the formula =ProductionOutput!H$21. Cell F3 then repeats the formula in E3 (=ProductionOutput!H$21) and so it continues. Obviously I want the formulas to be: =ProductionOutput!D$21 =ProductionOutput!F$21 =ProductionOutput!H$21 =ProductionOutput!J$21 and so on. Any help would be much appreciated. Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=509320 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy paste problem? | Excel Discussion (Misc queries) | |||
In Excel: Paste Special should have a "Link Value" Selection | Excel Worksheet Functions | |||
Macro Solution for Link Problem? | Excel Worksheet Functions | |||
Problem breaking a link | Excel Discussion (Misc queries) | |||
Problem with delays in Cut (Cntl-C) and Paste (Ctrl-V) in Excel | Excel Discussion (Misc queries) |