On Sunday, September 3, 2017 at 2:21:32 PM UTC+5:30, Bruno Campanini wrote:
shrini wrote on 01-09-17 :

I checked the linked which fulfil 50% of my requirement.
Available macro is to copy full data in summary sheet my requirement is that
I want to copy data which is specified by the user I dont want to copy
complete data Regards Shrini

1 - What file you want the procedure to be executed from?
2 - What are the keys to specify the data you want to copy?
3 - What are the paths of the files?

Bruno
Dear Burno
Thanks for reply.
Actually I have 2 work book . for Eg in first work book I have educational details of the person eg he has cleared his 10th,12th graduation etc and in second work book I have details like physical appreance about colour ,citizenship,cast etc.I have data more than 3000 person.Now customer comes to me and asking print out of particular person For eg details of "SHRINIVAS".Then in 3rd work book I will enter Name "SHRINIVAS" and macro should be able to take out details from both work book.
And I can take out the print of Shrinivas and can give it to customer .If another customer come and ask for the details of another person then details of Shrinivas will get deleted and Details of new person will appear.
Actually I dont know how to attahed file or else I could have been attached..
Thansk again for reply.