Hi Team,

I am looking for automation wherein I can copy paste data in notepad from excel. Below is my requirement, if any one of you can help me out with the coding, would be very kind of you:-

1) I have 3 sheets in 1 workbook in which I have Invoice Number as common field. ( Sheet Naming Sheet 1 - Header, Sheet 2 - Line Items, Sheet 3 - Charges)

- Now Invoice Number will be my Header ID with relevant data (present in Sheet 1 - Header), and for respective header there will be multiple Line Items (present in Sheet 2 - Line Items) with the reference of Invoice Number, and in Sheet 3 - Charges, Invoice Number and line item number I need to enter charges.

example data
Sheet 1 data:-
Invoice Number "Invoice Date(yyyy-mm-dd)" Invoice Amount
testInv12 2015-06-01 800

Sheet 2 data
Invoice Number Invoice Line Number Invoice Quantity
testInv12 1 44.3
testInv12 2 20

Sheet 3 data
Invoice Number Invoice Line Number Account Line Number Account Amount
testInv12 1 1 ledger1 10
testInv12 1 2 ledger2 20
testInv12 2 1 ledger3 30


this is just for an example of One data, Now I want code which can copy paste data in notepad with relevant line item wise meaning, code should pick 1st line of header, then below to that header respective line items relevant to that header Invoice number only and then Charges data relevant to the same Invoice, I have huge data with me and it is very much time taking work for me to filter all the three sheets with same invoice. Please help me with coding. \
Thanks in Advance