Macro to CopyPaste from one excel to another using a reference number in a column

[Rakesh99932]

Hi,
I have 2 excel sheets. Requirement & Destination (Both placed below). Need to copy and paste few data from Requirement to Destination.

Requirement:
1. Copy values in column F (yellow highlighted) of the 1st Department from Requirement Excel and paste in Column E (Yellow highlighted) of the 1st Department in the Destination Excel.
2. Need the above steps to be done for all the Departments in the file, although I had mentioned only 2 departments, there will be multiple in real.
3. But in some cases, in the destination excel, there might be extra rows highlighted in RED, which we can ignore, and paste the values from row number 18 as shown below.

Kindly help me to achieve this and please let me know if you need further clarifications.

Requirement.xlsx
	A	B	C	D	E	F	G	H
1	DEPARTMENT			CLIENT TYPES	QUESTIONNAIRE
2	Main Dept	DEPT ID .1	DEPT NAME	IID PRC .1	OLD - QUEST ID	NEW - QUESTI ID	BEFORE APPT	RULE
3	Last, First			53015786	.530158786	53020543	.530204545	530307876
4
5	Main Dept 1	1st Department	Hamilton Ham	618	15550	2020700	7	2100015500
6				10461	15550	2020700	7	2100015500
7				5761	15551	2020701	7	2100015501
8				10461	15551	2020701	7	2100015501
9				616	15307	2020710	7	2100015502
10				5761	15307	2020710	7	2100015502
11				10460	15307	2020710	7	2100015502
12				618	15552	2020702	7	2100015503
13				10461	15552	2020702	7	2100015503
14				5761	15552	2020702	7	2100015503
15		2nd Department	SI BUL PAL	618	15550	2020704	7	2100015505
16				10461	15550	2020705	7	2100015506
17				5761	15551	2020705	7	2100015506
18				10461	15551	2020705	7	2100015506
19				616	15307	2020706	7	2100015507
20				5761	15307	2020706	7	2100015507
21				10460	15307	2020706	7	2100015507
22				618	15552	2020707	7	2100015508
23				10461	15552	2020707	7	2100015508
24				5761	15552	2020707	7	2100015508
Requirement

Destination.xlsx
	A	B	C	D	E	F	G	H	I
1	.1	.2	53015786	.530158786	53020543	.530204545	530307876	530354789	.5303575433
2
3	category	category	category	category	category	category	category	category	category
4		a	b	c	d	e	f	g	h
5	Dept Id	DEPT NAME	VISIT TYPE	VISIT TYPE NAME	VISIT TYPE ID	VISIT TYPE Des	# DAYS BEFORE APPT	QUESTIONNAIRE	APPT
6	1st Department	Hamilton Hamil Ha	618	Name	15550	Fes	7	2100015500	South Health
7			10461	Name	15550	Fes	7	2100015500	South Health
8			5761	Name	15551	Fes	7	2100015501	South Health
9			10461	Name	15551	Fes	7	2100015501	South Health
10			616	Name	15307	Fes	7	2100015502	South Health
11			5761	Name	15307	Fes	7	2100015502	South Health
12			10460	Name	15307	Fes	7	2100015502	South Health
13			618	Name	15552	Fes	7	2100015503	South Health
14			10461	Name	15552	Fes	7	2100015503	South Health
15			5761	Name	15552	Fes	7	2100015503	South Health
16	2nd Department	SI BUL Palminton	999	Name	15552	Fes	7	2100015503	South Health
17			888	Name	15553	Fes	7	2100015504	South Health
18			618	Name	15550	Fes	7	2100015500	South Health
19			10461	Name	15550	Fes	7	2100015500	South Health
20			5761	Name	15551	Fes	7	2100015501	South Health
21			10461	Name	15551	Fes	7	2100015501	South Health
22			616	Name	15307	Fes	7	2100015502	South Health
23			5761	Name	15307	Fes	7	2100015502	South Health
24			10460	Name	15307	Fes	7	2100015502	South Health
25			618	Name	15552	Fes	7	2100015503	South Health
26			10461	Name	15552	Fes	7	2100015503	South Health
27			5761	Name	15552	Fes	7	2100015503	South Health
Destination

 

[Zot]

Is your Destination file being set up beforehand with same number of row as the Requirement file (i.e. are the two file are having fix number of row?