• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

CAN THIS SHEET BE AUTOMATED?

saqibhanif37

New Member
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.
 

Attachments

  • Audit Plan 2019 v.2 (1).xlsx
    245.9 KB · Views: 2
Hi:

You can achieve a similar format using power query..

Thanks
 

Attachments

  • Audit Plan 2019 v.2 (1).xlsx
    253 KB · Views: 4
Back
Top