Very much Thankful for your help. I got what i was looking for from the provided link, however, would require one more help by adding prompt in below code. as i am new in VBA.
1- Locate file.
2- Prompt me for path for saving file.
3- Prompt me for Input Field (Numeric Value) i.e. 1
4-...
Could you please help for the Macro, which filter, cut and paste data into a new workbooks. But it also filter only those code which defined by me. i.e. 7012, 7024, 7014, and automatically saves the workbook with same id.
Dealer_Code MOBILE IMSI CUSTOMERNAME DATE SALE DATE
7000 mobile 1...