Hi,
I have data Month wise in different tabs in Excel. I want to create a Master sheet in the same workbook and get the data date wise from the other tabs in order.
For Eg: I have Tabs from July to December - 2022. I want the data entered in July Tab to automatically update in Master sheet Tab whenever a line is added. All the Tabs will have the same header. I tried the consolidate function, but it asks for calculation options, which I don't want to use. All I need is simple data consolidation. Any help is greatly appreciated.
Thanks,
Abrar.
I have data Month wise in different tabs in Excel. I want to create a Master sheet in the same workbook and get the data date wise from the other tabs in order.
For Eg: I have Tabs from July to December - 2022. I want the data entered in July Tab to automatically update in Master sheet Tab whenever a line is added. All the Tabs will have the same header. I tried the consolidate function, but it asks for calculation options, which I don't want to use. All I need is simple data consolidation. Any help is greatly appreciated.
Thanks,
Abrar.