Helloo in my excel I have
Sheet A where in Column J i have IDs
I also have so many sheets as IDs and every Sheet's name is ID number
So I have sheet named 1.1
sheet named 1.2, 1.3, 1.4 etc
Also I have Sheet named 'Import"
I'd like to have a loop which first will get first ID from Sheet A = 1.1
Then will open sheet named 1.1 and copy data from column A9:A, B9:B,C9:C
And paste it into "Import" Sheet to colums N1:N, O1:O, P1:P on matched ID from column "L" and move entire row Data 1 bellow idk how many rows because every time in Sheet named 1.1, 1.2 there are different values.
Then fuction will get next ID 1.2 from sheet A, open sheet 1.2 and do the same
SHEET A
NOW MY IMPORT SHEET LOOKS LIKE
IMPORT SHEET - EXPECTED RESULT
Sheet A where in Column J i have IDs
I also have so many sheets as IDs and every Sheet's name is ID number
So I have sheet named 1.1
sheet named 1.2, 1.3, 1.4 etc
Also I have Sheet named 'Import"
I'd like to have a loop which first will get first ID from Sheet A = 1.1
Then will open sheet named 1.1 and copy data from column A9:A, B9:B,C9:C
And paste it into "Import" Sheet to colums N1:N, O1:O, P1:P on matched ID from column "L" and move entire row Data 1 bellow idk how many rows because every time in Sheet named 1.1, 1.2 there are different values.
Then fuction will get next ID 1.2 from sheet A, open sheet 1.2 and do the same
N | O | P | ||
9 | SOME DATA3 | SOME DATA4 | SOME DATA5 | |
10 | SOME DATA6 | SOME DATA 7 | SOME DATA8 | |
11 | SOME DATA 9 | SOME DATA 10 | SOME DATA 11 |
SHEET A
J (ID) | |
1 | 1.1 |
2 | 1.2 |
3 | 1.3 |
NOW MY IMPORT SHEET LOOKS LIKE
K | L | M | N | O | P | |
TEST | 1.1 | SOME DATA | ||||
ANOTHER TEST | 1.2 | SOME DATA |
IMPORT SHEET - EXPECTED RESULT
K | L | M | N | O | P |
TEST | 1.1 | SOME DATA | SOME DATA3 | SOME DATA4 | SOME DATA5 |
SOME DATA6 | SOME DATA7 | SOME DATA8 | |||
SOME DATA9 | SOME DATA10 | SOME DATA11 | |||
ANOTHER TEST | 1.2 | SOME DATA |