Copy data from one sheet to another based on value in sheet and copy multiple columns from 9 row

bubsk

New Member
Joined
Mar 24, 2020
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
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

NOP
9SOME DATA3SOME DATA4SOME DATA5
10SOME DATA6SOME DATA 7SOME DATA8
11SOME DATA 9SOME DATA 10SOME DATA 11


SHEET A

J (ID)
11.1
21.2
31.3

NOW MY IMPORT SHEET LOOKS LIKE
KLMNOP
TEST1.1SOME DATA
ANOTHER TEST1.2SOME DATA


IMPORT SHEET - EXPECTED RESULT
KLMNOP
TEST1.1SOME DATASOME DATA3SOME DATA4SOME DATA5
SOME DATA6SOME DATA7SOME DATA8
SOME DATA9SOME DATA10SOME DATA11
ANOTHER TEST1.2SOME DATA
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,888
Messages
6,175,203
Members
452,617
Latest member
Narendra Babu D

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top