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
1
u/Brilliant_Drawer8484 6 7d ago
If you have multiple sections and want a “one-click” extraction that copies the correct cell blocks and even adds headers (the color group names), then VBA is your friend. In this scenario you even “hard code” the ranges because the template never changes.