Is there any way to fill in one master sheet only and then this will
automatically fill in the other sheets on the same file by checking if master
sheet has been modified by something new which isnt in the rother sheets.
Eg: master sheet contains all the debtors which I update on regular basis.
Other tabs use €˜vlookup or €˜sumif formulas to calculate and present eg 90
days+ debts outstanding, Total Debts outstanding, list of all the debtors,
list of new debtors etc.
If there is a new entry on the master tab, other tabs wont pick this info
until I €˜vlookup on the master tab, look for errors (#N/A) then manually
pate to the respective tabs.
Is there any way for each tab to find/pick any new entry from the master tab?
Please help. Thanks in advance.