Copy & Paste to another sheet

[Pratapherono1]

Hi Master,

Need your expertise in building a VBA to copy the data from Sheet 1 and transpose paste in Sheet 2 – As per the below format:

Sheet 1 (will have a pivot in the below format) - Data needs to be copied from this sheet:

A	B	C	D
ID	GBP	USD	Grand Total
12345		220675.50	220675.50
11233		-6180.33	-6180.33
27736	-18997.79	-2445.00	-21442.79
Grand Total	-18997.79	212050.17	193052.38

<tbody>
</tbody>

Sheet 2 (will have a table in the below format) – Data needs to be pasted in this sheet:

A	B	C	D	E	F	G	H
S. No.	Batch	Date	Date	Type	ID	CCY	Amount
1	Batch1	7-Sep-18	7-Sep-18	ABC	12345	USD	220,675.50
2	Batch1	7-Sep-18	7-Sep-18	XYZ	11233	USD	-6,180.33
3	Batch1	7-Sep-18	7-Sep-18	XYZ	27736	GBP	-18,997.79
4	Batch1	7-Sep-18	7-Sep-18	XYZ	27736	USD	-2,445.00

<tbody>
</tbody>

Key Rule:Data from column A, B & C (in Sheet 1) to be copied and pasted accordingly in F, G & H (in Sheet 2) – Please note that the data in Sheet 2 is historical – Hence, the paste should be based on next available row (in Col F) in Sheet 2.

Note: In the above example – there are just 3 IDs & 2 Currencies in the pivot – there could be upto 50 IDs & 30 Currencies (might differ based on data).

Your help in building a VBA – which could save about 3 hours of daily life.

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1072719-copy-data-one-sheet-another-post5152790.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.