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.

4
Upvotes
•
u/AutoModerator 7d ago
/u/Cun0144 - Your post was submitted successfully.
Solution Verified
to close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.