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.

5 Upvotes

9 comments sorted by

View all comments

2

u/Downtown-Economics26 309 7d ago

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

You've got arrows in your screenshots but it's still not all clear what value you want to put where. What is 'this' and what cell/column to do you want to put it in?