Hi,
I need help in consolidating data in excel.
In my case, Consolidated data is not updating if I delete or modify input sheet.
Case 1: If I newly add information in cell ‘B5’ in ‘Input sheet’ then in ‘Consolidated Data’ sheet, cell ‘D7’ is not updating automatically. Cell ‘D7’ shall show...