Pull Data with the same Key ID for multiple entries & import it to different worksheets - Google Sheets

[murexcel]

Hello,

We have a list of data that has multiple entries, but many of them have the same member ID. The data in every row is different; only the member ID is common.

We have created different Google Sheets for members, and when we add the data with the member ID to the main sheet, it should create a new row in the sheet for the specific member.

DATA.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	MEMBER ID	COL1	COL2	COL3	COL4	COL5	COL6	COL7	COL8	COL9	COL10	COL11	COL12
2	MH1	12345678	5409	ABCD	123	123	ABCD	ABCD			1	ABCD	ABCD
3	MH2	12345678	4443	ABCD	123	211	ABCD	ABCD			1	ABCD	ABCD
4	MH1	12345678	4204	ABCD	123	2	ABCD	ABCD			1	ABCD	ABCD
5	MH1	12345678	531	ABCD	123	214	ABCD	ABCD			1	ABCD	ABCD
6	MH1	12345678	1643	ABCD	123	M002	ABCD	ABCD			1	ABCD	ABCD
7	MH6	12345678	4125	ABCD	123	108	ABCD	ABCD		1		ABCD	ABCD
8	MH7	12345678	845	ABCD	123	1 103	ABCD	ABCD			1	ABCD	ABCD
9	MH1	12345678	573	ABCD	123	230	ABCD	ABCD		1		ABCD	ABCD
10	MH1	12345678	2780	ABCD	123	303	ABCD	ABCD		1		ABCD	ABCD
11	MH10	12345678	5321	ABCD	123	322	ABCD	ABCD			1	ABCD	ABCD
Sheet1

In this I want to pull data with Member ID with MH1 into a different Google Sheet & whenever new data is added for this id, a new row should be added to the Member ID. I have tried a few Array formulas with Vlookup , but I'm not getting the desired result.

Thanks in advance for the help.

 

[veyselemre]

Hi,

=Query(IMPORTRANGE("Your main google sheet url/only ID", "Sheet1!A1:M"), "SELECT * WHERE Col1='MH1' ")

=QUERY(importrange("1LA.........................8","gelenAramalar!A3:G"),"SELECT * WHERE Col1 IS NOT NULL")