Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas
I am trying to take one figure from a spreadsheet workbook and carry this
accross to another worksheet no calculations are required i just need to carry the data accross please help! -- Thanks for your help! Lou |
#2
|
|||
|
|||
Hi,
Not sure if i understand exactly what you mean but maybe this will help: If you want to copy cell F10 from 1 worksheet to another (within the same ..XLS spreadsheet file) and if the original cell changes and you want to see this reflected in the copy try this formula in the cell where you want to see the data copied to: ='Copied Worksheet Name'!F10 If you want to copy a call from 1 workbook to another (e.g 1 XLS spreadhset file to another) try this: ='[Copied Workbook Name.xls]Copied Worksheet Name'!F10 Hope this is what you are looking for. If not, maybe if you choose 'paste special' instead of paste when you are doing the copying, one of the options here might be what you are looking for. you can copy just values or just formulas etc. "lou kynoch" wrote: I am trying to take one figure from a spreadsheet workbook and carry this accross to another worksheet no calculations are required i just need to carry the data accross please help! -- Thanks for your help! Lou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |