Macro to import data based on 2 criteria

[jimbobakoo]

Hello,

What I need is a macro which will copy and paste data into different places depending on the corresponding information in the same row.

e.g. 1. Sheet "Data" Row "3" contains:

A	B	C	D	E	F
1	10:00 AM	THE NUT JOB 2D	U	11:36 AM	SA,SU

The 2 deciding factors are in column "A" (screen number) and "F" (week day)

this means that in Sheet "Organised": "E9" & "E13" need to contain "THE NUT JOB 2D", "C9" & "C13" need to contain "10:00 AM" and "D9" & "D13" needs to contain "11:36 AM"

This is because Column "A" indicates which screen header it should be under and Column "F" decides which days it need to be beside (SA = Saturday etc)

I am completely open to any ideas, if you think this could be achievable with formulas, I am happy to try that.

Many thanks!

[jimbobakoo]

Just in case you need another example to clarify things further, Sheet "Data" Row "4" contains:

A	B	C	D	E	f
7	10:00 AM	THE PENGUINS OF MADAGASCAR 2D	U	11:57 AM	SA,SU

This means that in Sheet "Organised": "W9" & "W13" need to contain "THE PENGUINS OF MADAGASCAR 2D", "U9" & "U13" need to contain "10:00 AM" and "V9" & "V13" needs to contain "11:57 AM"

[jimbobakoo]

Its the fact that I have 2 criteria to sort by which stumps me. this makes 133 different variables which the days could be and 12 variables the screens could be, which would 1596 different possible outcomes if something like 'IF' statements were used. I'm guessing some form of 'LOOKUP' will have to be used, or first create an array with the data?

[jimbobakoo]

Don't want to sound needy, but is this even possible? Usually my posts get answered pretty sharpish on here.

Thanks again all.