I need to Extract data from sheet 1 and match with column names of sheet 2 if match found i need to get data of respective column refer the attached excel

kalyan256 · December 14, 2020, 6:03am

NIVED_NAMBIAR · December 14, 2020, 10:36am

Hi @kalyan256 welcome back to forum

Check this workflow
excel.zip (54.3 KB)

Mark it as solution if it helps

Regards
Nived N
Happy Automation

kalyan256 · December 15, 2020, 4:18am

Hi Nived i need to write the extracted data into sheet 3 of matching column names

system · December 18, 2020, 4:18am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
I need to get Column names from "column name" column from sheet 1 and write to sheet2 as column names please find attached excel Help datatable , excel , uiautomation , studio , data_scraping , string , question , data_manipulation	2	668	December 24, 2020
Extract Not matched data from Excel Help datatable , excel , studio	2	671	October 19, 2020
Extracting more than two column values from datatable based on specific column Academic Alliance datatable , excel , uiautomation , studio	6	1081	October 4, 2020
[Question] in excel automation Help studio , question	4	663	December 24, 2020
Text to Excel data Extraction Help	5	1001	April 26, 2019