Advance Search

[soodaarti21]

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

 

[northwolves]

Use advancedfilter and record a macro.

 

[soodaarti21]

thanks, I did d same thing with few changes n its working....