Copy & Paste from workbook to another with criterias

[Anthony86]

Hi All,

Looking for help with a copy and paste from one workbook to another with a certain criteria.

I'll need data copied from B3:C68 and pasted to another workbook(test1.xlsm) but different sheets/columns depending on the day. The source range will never change(B3:C68), what will change will be day and shift. The day value is in cell F3 & Shift value in H3

Destination file;

Depending on the day, the code will need to search workbook for the correct sheet;
Sunday=Sun
Monday=Mon
Tuesday=Tues
Wednesday=Wed
Thursday=Thur
Friday=Fri
Saturday=Sat

and paste the data in B6:C72 if the shift value is A or B, if shift value is C or D then it needs to be pasted into G6:H72

 

[Anthony86]

Anyone got any suggestions?

 

[Anthony86]

Any vba experts here that could help if this is even possible?