Actually I dont have any spesific data to referred, only just wonder if it can be done to export the data to another workbook (whether open or closed) by click on selected row in searchbox from active workbook.
Let's says, the data found in active workbook searchbox is in Row 7, then when click on it (in searchbox) so the data will be exported to another workbook. Not necessery to export all the data, maybe need it in Cell D7, F7 & K7 only to export. And target workbook will filled with the exported data to B4(D7), G8(F7) & L9(K7).
Can it be done using VBA codes? Maybe have to created Userform as a 'Find and Replace' box? Maybe there is another way can make it done? Thank you very much in advance if you accept this challenge and wish you good luck.
Post code here: