Macro to Move cells from one sheet to another if conditions meet [Closed]

Report
-
Hello,

I have Sheet with Two Columns and several rows.. This gets edited each week. But i want to copy these values onto another sheet. with similiar rows and multiple columns ( Spread by week).

For common, i have week Nos listed on both page.. ( Like Week 41, Week 42).

So in my master 1st page, if i change the week to Week 42, then running a macro. i should get the values of rows amd columns onto the second sheet column labeslled week 42/

How do i create a macro to run this automatically.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!