N excel some say it is pivot table feature or other software
Whereas you enter a figure say apple amounts in the main ledger
Or worksheet and it automatically updates a sub ledger
Or another worksheet with the new information. I already know about linking the worksheets together in excel with hyperlink. But that is not what I am looking for. Is there software that can do this type of operation?