PDA

View Full Version : Search and Paste



Ildestino
05-08-2015, 05:56 AM
Dear Excel Gurus!


I am seeking for your guidance and help, then I am a nobody compare to you


I am working on a database that will be used by many people. now every user has a "Key" that can be typed in this search (please see the example workbook). With this Key, it should search in the whole workbook for the given value and if results are found, it should copy the results in to a new workbook with the same header, worksheet by worksheet.


Do you think its possible? If yes, could you please help?


Thank you very much in advance.


Kind regards
I

13308