VBA help with IF function

[DrH100]

I really struggle with IF in VBA and have no idea where to go with this as there are two criteria to match.

I have a simple enough work book with two sheets - in sheet1 the user inputs a day in A1 (from drop down) and an indicator (either 1 or 2) in B1

What I am trying to do is

IF A1 = Monday and B1 = 1 copy column C and paste in Sheet2
IF A1 = Monday and B1 = 2 copy column D and paste in Sheet2
IF A1 = Tuesday and B1 = 1 copy column E and paste in Sheet 2
If A1 = Tuesday and B1 = 2 copy column F and paste in Sheet 2

And so on through to Friday

Can someone advise where the best place to start is. Once I've got two or three IF's in place I can usually add the others in but I can't seem to find any examples of more than one criteria.

If anybody has any links to "simple" to understand guides to using IFs in VBA I would be most grateful also as I feel that this is something that I should be able to understand but can't get my head around at all at the moment.

Many thanks for any help in advance

 

[Scott Huish]

Basically you just put ANDs or ORs between complete criteria.

If Range("A1")="Monday" And Range("B1")=1 Then ...

 

[DrH100]

Basically you just put ANDs or ORs between complete criteria.

If Range("A1")="Monday" And Range("B1")=1 Then ...

Thanks scott - I think sometimes I over think things and try to make it too difficult