hello friends.........
i am looking for a code for vlookup which can help me sorting the data
1. "Deletion" sheet have some E_Code No. (in Col-B) which are already exist in "Sheet1" 's Col-B. i want to match "Deletion" sheet's E_Code (Col-B) in "Sheet1's" (Col-B)E_Code and data should be show in Col-G of "Sheet1"
2. after that i want to sort the data of Col-G..............
3. after sort the data in Sheet1, see the sheet "DD" i want to copy the data A2 to G2 and paste the data before 1st "#N/A" in sheet1
4. after that i want to rearrange the serial no "please see the "Result_Sheet"
3. after that in Col-G of Sheet1 find the First "#N/A" here i want to insert 10blank rows before 1st "#n/a" of Col-G
4. after that i want to paste the heading of A1 to G1 in the very next row i.e. 10th row
5. after that i want to sort it in Col-F and rearrange the serial no and make a total of AMT-2 after last fill row(please see the Result_Sheet for ready reference)
thats it
Bookmarks