I am trying to populate an excel sheet ('Actuals') based on values in another
excel sheet ('Budget') in the same file. When the Week Number is chosen, from
drop down list (based on 'Budget') I need certain columns to populate. For
example if user chooses Week 1, I need Column C, F and J on the 'Actuals'
sheet to read Y but if week 4 is choosen, Coumns D,I, M and N will be Y.

How can I make this happen?

Thanks