CAN THIS SHEET BE AUTOMATED?

[saqibhanif37]

Dear All,
My name is Saqib. I am struggling with this excel sheet almost all the time. I have a table on Sheet "Stock take plan", which needs to be summarised into a sheet named "REQUIRED" the way it is. I make the "Required" Sheet every time from scratch. Is there a way that the "Stock Take plan" sheet can reflect changes in the "Required" Sheet?

Thanks in advance.

 

[Nebu]

Hi:

You can achieve a similar format using power query..

Thanks

 

[saqibhanif37]

THANK YOU SO MUCH! MERGE WILL HELP ME WITH THE REST HOPEFULLY!