如何编写一个查看特定值的宏，然后将其复制并粘贴到另一个工作表上的特定位置

I am new to writing VBA and I have had some trouble writing a code. I have searched through all the different questions people have asked with similar issues to mine and although there has been very similar questions asked I cannot find a way of applying them to my problem. I am creating a schedule based on a list of priorities. On one worksheet "Organisation Tab 2" I have assigned a rank number to each operation which needs scheduling. There are 35 ranks assigned.I am new to writing VBA and I have had some tro