linking formulas using multiple sheets

[ankitsondhi]

Hi,

I'm working on multiple worksheets and linking formulas from one to another. One of my spreadhseet is the summary sheet and it summarize the answer from different worksheets.

My question is :

In one of the worksheet I have to update data every month and I linked this data to the formula whcih gives me an answer in the summary sheet.
Is there any way if I can change the previous data but the answer I already got still remain the same aand give me new answer in another column.

Thanks
Ankit

 

[Robert Mika]

Hi,

I'm working on multiple worksheets and linking formulas from one to another. One of my spreadhseet is the summary sheet and it summarize the answer from different worksheets.

My question is :

In one of the worksheet I have to update data every month and I linked this data to the formula whcih gives me an answer in the summary sheet.
Is there any way if I can change the previous data but the answer I already got still remain the same aand give me new answer in another column.

Thanks
Ankit

Hello and welcome.
Could you post an example?