(Yet) Another Sheet Copying Problem

[airforceone]

good day to all!

I don't know if its the lack of sleep or what! but can't seems to find the problem
I'm trying to copy all records from sheet (source) to the lastrow of another sheet (target) with the following code

For iLOOP = 2 To FinalRow
' METHOD 1
    Worksheets("TARGET").Range("A" & TargetLastRow & ":" & TargetLastColumnLetter & TargetLastRow).Value = Worksheets("SOURCE").Range("A" & iLOOP & ":" & LastChar & iLOOP).Value
' METHOD 2
    Worksheets("SOURCE").Range("A" & iLOOP & ":" & LColX00 & iLOOP).Copy Destination:=Worksheets("TARGET").Range("A" & TargetLastRow & ":" & TargetLastColumnLetter & TargetLastRow)
    cTr = cTr + 1
Next

with the following error
(METHOD 1) - Run-time error 1004 - Application-Defined or Object-Defined error
(METHOD 2) - Run-time error 9 - Subscript out of range

 

[footoo]

Have you checked the values assigned to all the variables?
Method 1 needs the source and target ranges to be the same size. Cannot verify from the code you posted.
It appears unlikely that you need a loop.

 

[airforceone]

Have you checked the values assigned to all the variables?
Method 1 needs the source and target ranges to be the same size. Cannot verify from the code you posted.
It appears unlikely that you need a loop.

thanks mate, yap size differs from Sheet Source (4582 rows) and Sheet Target (229 rows)
though I manage to solved the my problem with a different solution, I would still love to solve the problem presented. I'll try to upload dummy records for referrence..

 

[airforceone]

up... sample dummy records

00 DUMMY ZERO - II.xlsx
	A	B	C	D
1	SPECIE	COUNTRY	STATUS	GENDER
2	American flamingo	Afghanistan	Hatched	F
3	Alcids	Afghanistan	Hatched	F
4	Amazon kingfisher	Afghanistan	Hatched	F
5	Albatrosses	Afghanistan	Sold	F
6	Albatrosses	Afghanistan	Sold	F
7	Accipiter hawks	Afghanistan	Sold	F
8	Accipiter hawks	Afghanistan	Sold	F
9	American dipper	Albania	Hatched	F
10	Accipiter hawks	Albania	Hatched	F
11	Albatrosses	Albania	Sold	F,F
12	American flamingo	Algeria	Hatched	F,F
13	Albatrosses	Algeria	Sold	F,F
14	Albatrosses	Algeria	Sold	F,F
15	Accipiter hawks	Algeria	Sold	F,F
16	American dipper	Andorra	Hatched	F,F
17	Alcids	Andorra	Hatched	F,F,F,F
18	Albatrosses	Andorra	Sold	F,F,M,F
19	Albatrosses	Andorra	Hatched	F,M
20	Accipiter hawks	Andorra	Sold	F,M
21	Albatrosses	Angola	Sold	F,M
22	Accipiter hawks	Angola	Sold	F,M
23	Albatrosses	Antigua and Barbuda	Sold	F,M
24	Albatrosses	Antigua and Barbuda	Sold	F,M
25	Albatrosses	Antigua and Barbuda	Sold	F,M
26	Albatrosses	Antigua and Barbuda	Sold	F,M
27	Albatrosses	Antigua and Barbuda	Sold	F,M
28	Albatrosses	Antigua and Barbuda	Sold	F,M
29	Accipiter hawks	Antigua and Barbuda	Sold	F,M
30	Accipiter hawks	Antigua and Barbuda	Sold	F,M
31	Accipiter hawks	Antigua and Barbuda	Sold	M
32	Accipiter hawks	Antigua and Barbuda	Sold	M
33	Accipiter hawks	Antigua and Barbuda	Sold	M
34	Albatrosses	Argentina	Sold	M
35	Albatrosses	Argentina	Sold	M
36	Accipiter hawks	Argentina	Sold	M
37	Accipiter hawks	Argentina	Sold	M
38	American dipper	Armenia	Hatched	M
39	American kestrel	Armenia	Hatched	M
40	American white pelican	Armenia	Hatched	M
41	American white pelican	Armenia	Hatched	M
42	American white pelican	Armenia	Hatched	M
43	Albatrosses	Armenia	Sold	M
44	Albatrosses	Armenia	Sold	M
45	Albatrosses	Armenia	Sold	M
46	Albatrosses	Armenia	Sold	M
47	Albatrosses	Armenia	Hatched	M
48	Albatrosses	Armenia	Sold	M
49	Albatrosses	Armenia	Sold	M
50	Alcids	Armenia	Hatched	M
51	Accipiter hawks	Armenia	Sold	M
52	Accipiter hawks	Armenia	Sold	M
53	Accipiter hawks	Armenia	Sold	M
54	American dipper	Australia	Hatched	M
55	American white pelican	Australia	Hatched	M
56	Accipiter hawks	Australia	Sold	M
57	Accipiter hawks	Australia	Hatched	M
58	American dipper	Austria	Hatched	M
59	American dipper	Austria	Hatched	M
60	American kestrel	Austria	Hatched	M
61	American white pelican	Austria	Hatched	M
62	American white pelican	Austria	Hatched	M
63	Albatrosses	Austria	Sold	M
64	Albatrosses	Austria	Sold	M
65	Albatrosses	Austria	Sold	M
66	Albatrosses	Austria	Sold	M
67	Albatrosses	Austria	Sold	M
68	Albatrosses	Austria	Sold	M
69	Albatrosses	Austria	Sold	M
70	Albatrosses	Austria	Sold	M
71	Accipiter hawks	Austria	Sold	M
72	Accipiter hawks	Austria	Sold	M
73	Accipiter hawks	Austria	Sold	M
74	Accipiter hawks	Austria	Sold	M
75	American kestrel	Azerbaijan	Hatched	M
76	Albatrosses	Azerbaijan	Sold	M
77	American dipper	Bahamas	Hatched	M
78	American white pelican	Bahrain	Hatched	M
79	American dipper	Bangladesh	Hatched	M
80	Alcids	Bangladesh	Hatched	M
81	Accipiter hawks	Bangladesh	Hatched	M
82	American dipper	Barbados	Hatched	M
83	American kestrel	Barbados	Sold	M
84	American kestrel	Barbados	Hatched	M
85	American white pelican	Barbados	Hatched	M
86	American white pelican	Barbados	Hatched	M
87	Alcids	Barbados	Hatched	M
88	Accipiter hawks	Barbados	Hatched	M
89	Albatrosses	Barbados	Sold	M
90	Albatrosses	Barbados	Sold	M
91	Albatrosses	Barbados	Sold	M
92	Accipiter hawks	Barbados	Sold	M
93	Accipiter hawks	Barbados	Sold	M
94	American dipper	Belarus	Hatched	M
95	American white pelican	Belarus	Hatched	M
96	American white pelican	Belarus	Hatched	M
97	American white pelican	Belarus	Hatched	M
98	American white pelican	Belarus	Hatched	M
99	American white pelican	Belarus	Hatched	M
100	Alcids	Belarus	Hatched	M,F
101	Accipiter hawks	Belarus	Hatched	M,F
102	Albatrosses	Belarus	Sold	M,F
103	Albatrosses	Belarus	Sold	M,F
104	Albatrosses	Belarus	Sold	M,F
105	Accipiter hawks	Belarus	Sold	M,F
106	Accipiter hawks	Belarus	Sold	M,F
107	Albatrosses	Belgium	Sold	M,F
108	Albatrosses	Belgium	Sold	M,F
109	Accipiter hawks	Belgium	Sold	M,F
110	Accipiter hawks	Belgium	Sold	M,F
111	Alcids	Belize	Sold	M,F
112	Albatrosses	Belize	Sold	M,F
113	Accipiter hawks	Belize	Sold	M,F
114	American white pelican	Benin	Hatched	M,F
115	American white pelican	Benin	Hatched	M,F
116	Alcids	Benin	Hatched	M,F
117	Amazon kingfisher	Benin	Sold	M,F
118	Albatrosses	Benin	Sold	M,F
119	Albatrosses	Benin	Sold	M,F
120	Albatrosses	Benin	Sold	M,F
121	Albatrosses	Benin	Sold	M,F
122	Accipiter hawks	Benin	Sold	M,M,M
123	Accipiter hawks	Benin	Sold	M,M,M
124	Accipiter hawks	Benin	Sold	M,M,M
125	Amazon kingfisher	Bhutan	Sold	M,M,M
126	Albatrosses	Bolivia	Sold	M,M,M
127	Albatrosses	Bolivia	Sold	M,M,M
128	Albatrosses	Bolivia	Sold	M,M,M
129	Accipiter hawks	Bolivia	Sold	M,M,M
130	Accipiter hawks	Bolivia	Sold	M,M,M
131	Accipiter hawks	Bolivia	Sold	M,M,M
132	Albatrosses	Bosnia and Herzegovina	Sold	M,M,M
133	Albatrosses	Bosnia and Herzegovina	Sold	M,M,M
134	American kestrel	Botswana	Hatched	M,M,M
135	Albatrosses	Botswana	Sold	M,M,M
136	Alcids	Botswana	Sold	N
TARGET

00 DUMMY ZERO - II.xlsx
	A	B	C
1	SPECIE	COUNTRY	STATUS
2	American flamingo	Afghanistan	Hatched
3	Alcids	Afghanistan	Hatched
4	Amazon kingfisher	Afghanistan	Hatched
5	Albatrosses	Afghanistan	Sold
6	Albatrosses	Afghanistan	Sold
7	Accipiter hawks	Afghanistan	Sold
8	Accipiter hawks	Afghanistan	Sold
9	American dipper	Albania	Hatched
10	Accipiter hawks	Albania	Hatched
11	Albatrosses	Albania	Sold
12	American flamingo	Algeria	Hatched
13	Albatrosses	Algeria	Sold
14	Albatrosses	Algeria	Sold
15	Accipiter hawks	Algeria	Sold
16	American dipper	Andorra	Hatched
17	Alcids	Andorra	Hatched
18	Albatrosses	Andorra	Sold
19	Albatrosses	Andorra	Hatched
20	Accipiter hawks	Andorra	Sold
SOURCE

 

[footoo]

What do you want to copy from where to where ?

 

[airforceone]

What do you want to copy from where to where ?

sorry for the late reply... already fix my problem but still thanks mate