Hi,
i have an excel file containing Accounts receivable invoice details .There are header rows containing customer name and in rows below each customer name (header ) details of invoices are given .
I want to copy and paste customer name (with Customer code) against each invoice row corresponding to that customer invoices in another column and make a datatable. Sample file attached.
Please advise.
Der is no attached file in your post
And can you show the SS for the Input and expect exact output for the same ?
Happy Automation 
Best Regards
Er Pratik Wavhal 
Dear Pratik ,
thanks for your reply, I am a new user not allowed to upload file. I have created a test data file and expected output. The input file is generated from SAGE 300 ERP .If you have email ID i can share with you the test data file.
Regards,
Vivek
If you have Gmail Account then can you upload your file on Google Drive der and then share the Link here for the same
Happy Automation
Best Regards
Er Pratik Wavhal
https://drive.google.com/file/d/1WrAVSqTLGj3oU846F0uJOTGyhqbkVEbM/view?usp=sharing
Hi
Please check the link
If possible can you please give the access
Happy Automation
Best Regards
Er Pratik Wavhal
hi,please check your mail
Below is the workflow for the same :-
MainPratik.xaml (12.1 KB)
Test data.xlsx (13.2 KB)
Mark as solution and like it if this helps you 
Happy Automation
Best Regards
Er Pratik Wavhal
Dear ,
Its not working .I need to copy the details from sheet 1 and prepare a table in “Expected datatable” sheet. as per the format provided .Please check
So the below img is not the output you are expecting which updates the sheet “Report” ??
Happy Automation
Best Regards
Er Pratik Wavhal
Hi this is the input file.output file is the table in “Expcted datatablesheet”.sorry for the misunderstanding
Have a look to the below workflow :-
MainVivek.xaml (23.9 KB)
Test data.xlsx (15.3 KB)
New Text Document.txt (162 Bytes)
Output :-
Mark as solution and like it if this helps you
Happy Automation
Best Regards
Er Pratik Wavhal
hi thanks its working …
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
