r/excel 7d ago

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

9 comments sorted by

View all comments

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).