Range based on two different cells.

[Jakub3]

Hi guys,

I hope you are well.

I can't seems to figure this one out.

I have two drop down lists, one has weeks: week1, week2... the other has weekdays: Monday, Tuesday...

How do I update range of cells based on this? Week1, Monday would have cells "mysheet!B1:C10 = week1B2:C11! week1 Tuesday would have another range and so on.

I know how to do only one cell using indirect function =INDIRECT("'" & $A$1 & "'!" & $A$2) but how do you translate it to the next cell? Or is there better way than using indirect? VBA can be used too.


Thank you very much in advance.

 

[Darren Bartrup]

How do I update range of cells based on this? Week1, Monday would have cells "mysheet!B1:C10 = week1B2:C11! week1 Tuesday would have another range and so on.

Not understanding how this would work - A1 contains the word "week1", A2 contains the word "Monday". How does that translate into "mysheet!B1:C10 = week1B2:C11! (assuming you mean week1!B2:C11).

 

[Jakub3]

Thank you for the reply Darren.

You are correct, that is wrong. Maybe I could simplify the questions. What would be the best way to get update range of cells from another worksheet based on two variables (sheet and range). I know how to do this for one cell with indirect function. But can I get whole range from one sheet to the other sheet? Thank you in advance.