Fill cells based on coordinates

Hello

I have 3 tables in one sheet,

Capture.PNG

In the 2nd sheet, I want to fill in the cells based on the coordinates listed in the Row & Column tables, using the data in the 3rd table.

Example, in the Column table, I have
8, 9, 10, 11, 12, 13 ...
Stands for Column H, I, J, K, L, M...

So the values should be:
H10 = O
I6 = A
I64 = R
I57 = R
I6 = R (if there are duplicates, the last filled one will do, doesn't matter)
J37 = R
J142 = R
J130 = R
K58 = R
K52 = R
K8 = A
etc....

I have an insane amount of data, and I used plenty of formulas to generate these cute little 3 tables in order to use to fill the required sheet.

Any help writing a code or formula to that automatically fills such data is highly appreciated.

Thanks in advance!

Hi,
Could you please upload excel file with your sample data?
Insane amount of data - but number of columns in each table is the same, right?

Hello, thank you for the reply.
I don't think this will work, the 2nd sheet size is different, and doesn't have the same format.
I will upload the excel file in the next reply.
Thanks

Excel sheet
I uploaded to dropbox.
Attach option didn't work.

I basically have one sheet per week.
And I need to fill this for an entire year, for multiple employees...

The weeks data should be filled in the last sheet, Schedule.
I created a Test sheet, the one I attached the image from in my original post.

Based on the daily tasks, each project entry in the Schedule sheet should have a code, R, A, O, etc...
These should be filled from each weekly sheet.

Thanks for the help.

https://www.dropbox.com/s/mguzz6x25x...heet.xlsx?dl=0

It doesn't need to be based on the coordinates.

If you disregard the 3 tables method, is there a way to automate the filling of the Schedule sheet from the data in each weekly sheet?

Thanks for the help.

Try this simple code:

Please Login or Register  to view this content.

This works like a charm.

Thanks a lot

Originally Posted by kasan

Try this simple code:

Please Login or Register  to view this content.

How if this code
In this Sheet to sort by ctiteria in rows .if value meet (=) with rows (this variabel makro)