soodaarti21
New Member
- Joined
- Jun 30, 2008
- Messages
- 48
hi,
I have two worksheets in my workbook (sheet 1 & sheet 2) and in the first worksheet (sheet 1) i have big data containg text n nos. now i want that whenerver a button is clicked in sheet 1 a input box appears and ask user to enter a no between 1 to 10.
Based on the input by the user i want to search all the records in sheet 1 (column I) and paste the entire record in sheet 2.
for eg. if the user has enter no. 5 and based on it if 10 records are found then all these 10 records should be copied in sheet 2
I have two worksheets in my workbook (sheet 1 & sheet 2) and in the first worksheet (sheet 1) i have big data containg text n nos. now i want that whenerver a button is clicked in sheet 1 a input box appears and ask user to enter a no between 1 to 10.
Based on the input by the user i want to search all the records in sheet 1 (column I) and paste the entire record in sheet 2.
for eg. if the user has enter no. 5 and based on it if 10 records are found then all these 10 records should be copied in sheet 2