copy dynamic range to another sheet in another workbook

[cscrajasekhar]

please guide me in copying dynamic range to another sheet in another workbook. please help me.

my file enclosed. copy from a2 to r39.

r39 may increase or decrease.
a b c d e f g h i j k l l m n o p q r

serial number	Bill Date	Mill Code	Name of the Mill	From	Ack No.	Date	Acceptance No.	Acceptance Date	GODOWN	BAGS	Gr-A	BAGS	Common	BAGS	Gr-A	BAGS	Common
13360	20-07-2019	abc123	name	name	2805	15-05-19	245	15-05-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13361	20-07-2019	abc123	name	name	3058	07-06-19	132	07-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13362	20-07-2019	abc123	name	name	3272	25-06-19	749	25-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13363	20-07-2019	abc123	name	name	3309	26-06-19	41	25-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13364	20-07-2019	abc123	name	name	3339	27-06-19	166	27-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13365	20-07-2019	abc123	name	name	3230	19-06-19	295	19-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13366	20-07-2019	abc123	name	name	3207	18-06-19	1717	18-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13367	20-07-2019	abc123	name	name	3147	14-06-19	1716	14-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13368	20-07-2019	abc123	name	name	3145	14-06-19	746	14-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13369	20-07-2019	abc123	name	name	3111	11-06-19	675	11-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13370	20-07-2019	abc123	name	name	3100	10-06-19	674	10-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13371	20-07-2019	abc123	name	name	3090	10-06-19	277	10-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13372	20-07-2019	abc123	name	name	3223	18-06-19	3223	18-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13373	20-07-2019	abc123	name	name	3224	18-06-19	3224	18-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13374	20-07-2019	abc123	name	name	3229	18-06-19	156	18-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13375	20-07-2019	abc123	name	name	3245	19-06-19	160	19-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13376	20-07-2019	abc123	name	name	3304	26-06-19	695	25-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13377	20-07-2019	abc123	name	name	3332	26-06-19	3332	26-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13378	20-07-2019	abc123	name	name	3348	27-06-19	339	27-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13379	20-07-2019	abc123	name	name	3353	27-06-19	3353	27-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13380	20-07-2019	abc123	name	name	3013	01-06-19	988	01-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13381	20-07-2019	abc123	name	name	3105	11-06-19	993	11-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13382	20-07-2019	abc123	name	name	3103	10-06-19	3103	10-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13383	20-07-2019	abc123	name	name	3072	10-06-19	135	10-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13384	20-07-2019	abc123	name	name	3158	15-06-19	150	15-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13385	20-07-2019	abc123	name	name	3174	15-06-19	744	15-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13386	20-07-2019	abc123	name	name	3453	16-07-19	770	16-07-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13387	20-07-2019	abc123	name	name	3425	12-07-19	769	12-07-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13388	20-07-2019	abc123	name	name	3403	11-07-19	768	11-07-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13389	20-07-2019	abc123	name	name	3396	11-07-19	767	11-07-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13390	20-07-2019	abc123	name	name	2857	20-05-19	765	17-05-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13391	20-07-2019	abc123	name	name	3371	28-06-19	764	28-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13392	20-07-2019	abc123	name	name	3360	28-06-19	763	28-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13393	20-07-2019	abc123	name	name	3357	28-06-19	59	28-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13394	20-07-2019	abc123	name	name	3302	25-06-19	345	25-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13395	20-07-2019	abc123	name	name	3299	25-06-19	762	25-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13396	20-07-2019	abc123	name	name	3255	24-06-19	3255	24-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
13397	20-07-2019	abc123	name	name	3251	24-06-19	760	24-06-19	name	540	10000.00.00	540	10000.00.00	540	10000.00.00	540	10000.00.00
										20520	380000.000	20520	380000.00.00	20520	380000.00.00	20520	380000.00.00 serial number Bill Date Mill Code Name of the Mill From Ack No. Date Acceptance No. Acceptance Date GODOWN BAGS Gr-A BAGS Common BAGS Gr-A BAGS Common 13360 20-07-2019 abc123 name name 2805 15-05-19 245 15-05-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13361 20-07-2019 abc123 name name 3058 07-06-19 132 07-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13362 20-07-2019 abc123 name name 3272 25-06-19 749 25-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13363 20-07-2019 abc123 name name 3309 26-06-19 41 25-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13364 20-07-2019 abc123 name name 3339 27-06-19 166 27-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13365 20-07-2019 abc123 name name 3230 19-06-19 295 19-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13366 20-07-2019 abc123 name name 3207 18-06-19 1717 18-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13367 20-07-2019 abc123 name name 3147 14-06-19 1716 14-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13368 20-07-2019 abc123 name name 3145 14-06-19 746 14-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13369 20-07-2019 abc123 name name 3111 11-06-19 675 11-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13370 20-07-2019 abc123 name name 3100 10-06-19 674 10-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13371 20-07-2019 abc123 name name 3090 10-06-19 277 10-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13372 20-07-2019 abc123 name name 3223 18-06-19 3223 18-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13373 20-07-2019 abc123 name name 3224 18-06-19 3224 18-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13374 20-07-2019 abc123 name name 3229 18-06-19 156 18-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13375 20-07-2019 abc123 name name 3245 19-06-19 160 19-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13376 20-07-2019 abc123 name name 3304 26-06-19 695 25-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13377 20-07-2019 abc123 name name 3332 26-06-19 3332 26-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13378 20-07-2019 abc123 name name 3348 27-06-19 339 27-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13379 20-07-2019 abc123 name name 3353 27-06-19 3353 27-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13380 20-07-2019 abc123 name name 3013 01-06-19 988 01-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13381 20-07-2019 abc123 name name 3105 11-06-19 993 11-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13382 20-07-2019 abc123 name name 3103 10-06-19 3103 10-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13383 20-07-2019 abc123 name name 3072 10-06-19 135 10-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13384 20-07-2019 abc123 name name 3158 15-06-19 150 15-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13385 20-07-2019 abc123 name name 3174 15-06-19 744 15-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13386 20-07-2019 abc123 name name 3453 16-07-19 770 16-07-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13387 20-07-2019 abc123 name name 3425 12-07-19 769 12-07-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13388 20-07-2019 abc123 name name 3403 11-07-19 768 11-07-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13389 20-07-2019 abc123 name name 3396 11-07-19 767 11-07-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13390 20-07-2019 abc123 name name 2857 20-05-19 765 17-05-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13391 20-07-2019 abc123 name name 3371 28-06-19 764 28-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13392 20-07-2019 abc123 name name 3360 28-06-19 763 28-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13393 20-07-2019 abc123 name name 3357 28-06-19 59 28-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13394 20-07-2019 abc123 name name 3302 25-06-19 345 25-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13395 20-07-2019 abc123 name name 3299 25-06-19 762 25-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13396 20-07-2019 abc123 name name 3255 24-06-19 3255 24-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 13397 20-07-2019 abc123 name name 3251 24-06-19 760 24-06-19 name 540 10000.00.00 540 10000.00.00 540 10000.00.00 540 10000.00.00 20520 380000.000 20520 380000.00.00 20520 380000.00.00 20520 380000.00.00 <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[footoo]

To set the dynamic range :

Dim rng As Range
Set rng = Range("A2:R" & Cells(Rows.Count, "A").End(xlUp).Row)