Excel to save new workbook based from base file

[exceluser9]

Hi Team,

I have below data in a workbook names Interview details and I have a base file which is named as data and both are files are save in C drive in a folder called data file

What i want is from interview details file i want below data to be copied and pasted in data file and save it with the name Candidate ID_Date of Interview_Candidate Name (i.e column A:B:C)

File data has 2 sheet which is named as page 1 & Page 2. I have mentioned in which cell the data needs to be pasted in page 1 and page 2. For each row of data it has to save a separate workbook

Page 1	Page 1	Page 1	Page 1	Page 1	Page1		Page 2	Page 2	Page 2
Candidate ID	Date of Interview	Candidate Name :	Technical skill 1	Technical skill 2	Technical skill 3		Candidate Name :	Candidate ID :	Interviewed On :
C14	K14	C16	T23	T25	T27		J5	Q5	X5
1003987271	07/04/2022	Priyanka Pavuluri	java	springboot	C+		Priyanka Pavuluri	1003987271	07/04/2022
1003987272	08/04/2022	Alex	Windows		C+		Alex	1003987272	08/04/2022
1003987273	09/04/2022	Arun	Excel	springboot			Arun	1003987273	09/04/2022
1003987274	10/04/2022	Joseph		springboot	C+		Joseph	1003987274	10/04/2022
1003987275	11/04/2022	Dileep	springboot	Oraxle	C+		Dileep	1003987275	11/04/2022

 

[exceluser9]

Hi Team,

Anyone can help?

 

[exceluser9]

Hi All,

Any help on this is much appreciated