Forum Discussion
applying data from one sheet to another,
When applying data from one sheet in a workbook to another sheet, the result is that the formula from the first sheet is showing in the other sheet rather than the result. How can I fix this please?
Copy data from one sheet (sheet A) in a workbook to another sheet (sheet B) will definitely copy formula & link it from the first sheet (sheet A).
Hence data of another sheet (sheet B) will depend on first sheet (sheet A).
To prevent this you should copy sheet (by right click on first sheet (sheet A)) from first sheet in a workbook.
This only copy formulas which will absolutely related to the new sheet only (sheet B).
2 Replies
Copy data from one sheet (sheet A) in a workbook to another sheet (sheet B) will definitely copy formula & link it from the first sheet (sheet A).
Hence data of another sheet (sheet B) will depend on first sheet (sheet A).
To prevent this you should copy sheet (by right click on first sheet (sheet A)) from first sheet in a workbook.
This only copy formulas which will absolutely related to the new sheet only (sheet B).
- Thank you very much. I was able to fix my problem. Much appreciated
