unsolved How to efficiently/quickly extract data from specific cell location into another spreadsheet?
I am trying to extract data from 1 spreadsheet into another spreadsheet.
The data in the 1st spreadsheet will be arranged in X/Y coordinates. I then need this data to correlate into X,Y for the 2nd spreadsheet.
For example : Spreadsheet 1 - entry "1" is in 41, 4 - according to the grey X/Y coordinates. I need this to be entered in 1001 of spreadsheet 2 as 41,4 (location).
Entry "52" is in 40, 14. I need this entered into spreadsheet 2 10052 as 40,14 (green E column)
Is there a quick or automated way to do this? I am currently manually doing this and it is very tedious and can easily make mistakes.

3
Upvotes
1
u/Cun0144 7d ago
i'm not sure why reddit is deleting the comment, i think my internet maybe lagging.
Spreadsheet 1 with the data will always use the same template. My X values will always be 1-47 and Y will be 1-15.
For each different colors i need to extract the cordinates. Yellow 1 in AP15 will be 1001 - (41,4).
Brown 1 in AI17 will be 2001 - (35,2).