How do you take a list on sheet A say B1:B10 and paste it like sheet B B1:B5 and the rest to sheet B M1:M5? So essentially M1=B6 from previous sheet and so on. I would like to use this in a VBA where the list is created by A1="yes" then a text is copied into B1.

I know it is something simple but I can't figure it out.