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.