Need to extract the data from one page to another page based on the unique numbe [Closed]

Question

Need to extract the data from one page to another page based on the unique numbe [Closed]

Report

LakshmiKanth - Sep 17, 2019 at 04:51 AM
Blocked Profile - Sep 17, 2019 at 07:18 AM

Hi
i have data like below mentioned format, need to extract and paste it in another sheet, please help me in it.

DEAL_NO DEAL_DATE APPLICATION_OFFICER LOAN_TYPE LOAN_AMOUNT TENURE CUSTOMER_NAME CUSTOMER_ID ADDRESS_TYPE CATEGORY ADDRESS
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTHOD RAVI 500 RESIDENCE APPLICANT ROAD NO 14,8-2-293/206/29,BANJARAHILLS,SRI VENKATE
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTHOD RAVI 500 OFFICE APPLICANT NIZAMPET KKP,KUKATPALLY,1ST FLOOR,H NO 1-2-317, HY
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTOTI BIKSHAM 501 RESIDENCE COAPPLICANT H NO 8-2-293/65/38/1,,KHAIRTABAD,ROAD NO 14,SRI VE
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTOTI BIKSHAM 501 OFFICE COAPPLICANT TELANAGN STSTE SECERATIRAT,TS STREET,REVENUVE DAPA
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTOTI YADAMMA 528 RESIDENCE COAPPLICANT H NO 8-2-293/65/38/1,,KHAIRTABAD,ROAD NO 14,SRI VE

need to make it in single line in another excel.

Need to extract the data from one page to another page based on the unique numbe
Extract specific data and convert to a date ✓ - Forum - Office Software
Possible to extract partial data in Excel? ✓ - Forum - Excel
Macro to extract specific data from excel - Forum - Excel
How do you pull data from one excel sheet to another based on criteria? ✓ - Forum - Excel
Excel copy data from one sheet to another automatically based on criteria - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2019-09-17T07:18:18-0400

Answer 1 / 1

Blocked Profile
Updated on Sep 17, 2019 at 07:18 AM

You need to be careful posting possible sensitive customer information on the web! I hope this is not actual customer data. You may be in violation of certain laws!!!

Need to extract the data from one page to another page based on the unique numbe [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!