Forum Discussion
applying data from one sheet to another,
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).
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
