UNIC0RN
New Member
- Joined
- Oct 9, 2017
- Messages
- 13
I have managed to create a userform in "Master" workbook which the function is to 'find all' in all worksheet from "Membership" workbook based on value added at text box and its working well, but it is halfway from my target. I need an assistance from expert to find out how to :- auto populate in the search textbox base on value "E17" from "Master" workbook.
- copy & paste certain data back to "Master" workbook by clicking the selected row (or maybe need a cmd button?) based on value choosed in result textbox as below:
"Membership" F cell value to "Master" cell S17
"Membership" J cell value to "Master" cell E17
"Membership" K cell value to "Master" cell S19
"Membership" L cell value to "Master" cell S21
"Membership" N cell value to "Master" cell E21
Thank you in advance.
- copy & paste certain data back to "Master" workbook by clicking the selected row (or maybe need a cmd button?) based on value choosed in result textbox as below:
"Membership" F cell value to "Master" cell S17
"Membership" J cell value to "Master" cell E17
"Membership" K cell value to "Master" cell S19
"Membership" L cell value to "Master" cell S21
"Membership" N cell value to "Master" cell E21
Thank you in advance.