Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using paste link
I'm tyring to sort out a spreadsheet that was previously made by someone else
that I'm required to use. The parent spreadsheet that has collaberated info from many other tabs has the formula =SUM('person'!B19) however when I "paste-link" the information from new pages I'm making - that are just copies of the originals so nothing has changed, the forumla comes over as ='person'!B19 Will both formulas do the same thing? They seem to but if not - how do I copy the current data to bring the SUM function over so I don't have to type it into 300 different feilds? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using paste link
Both formulas will do the same thing, since it is not necessary to SUM a
single cell. Personally, I prefer creating links this way: select the destination cell, type an =, select the source cell and press F4 until you get the reference style you want, then press enter. It creates a link but with better control over the referencing, for copying elsewhere. HTH, Bernie MS Excel MVP "daniesmiley" wrote in message ... I'm tyring to sort out a spreadsheet that was previously made by someone else that I'm required to use. The parent spreadsheet that has collaberated info from many other tabs has the formula =SUM('person'!B19) however when I "paste-link" the information from new pages I'm making - that are just copies of the originals so nothing has changed, the forumla comes over as ='person'!B19 Will both formulas do the same thing? They seem to but if not - how do I copy the current data to bring the SUM function over so I don't have to type it into 300 different feilds? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Formatting not retained using paste all and paste link | Excel Worksheet Functions | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |