Complex Micro/Formula to Search from one sheet and Return Value on other sheet

Recreated new thread as earlier thread having some problem and cant view 2nd page of earlier thread.
-------------
Hi there... firstly as said earlier thanks a lots for your complex micro on search pincode and generate courier name which was coolest.. in continuation on same file if possible i also require data sorting by courier names in separate micro.
once the courier names are assigned we have to manually give AirWayBill numbers to each shipment once that is done we make 3 sheets for each courier on same file then email each sheet to particular courier service as record for our daily shipments and print out for barcode scanning to enter shipping details.
Sample Excel SalesHistory with full data here.

What Micro Should do is :
1) Create 3 new sheets with name Aramex, Bluedart & DTDC.
2) Sort data and Search Aramex from 'SalesHistory' Sheet and paste the data on 'Aramex' Sheet and so on for other 2 couriers (data only be copy and pasted in new sheet, original sheet remains unchanged)
3) Now on each new sheet change "Courier" field and make it as 'Sr No'
4) Change the formatting of AWB Number.
a) first add '*' in front and back of the AWB number that is for Barcode scanning.
b) change the Font for the AWB field as "CODE39" and font size as 28.
5) As you can see in sample excel not all fields are required hence after sorting delete the extra fields, vary for each courier data.

help on this would be highly appreciated as 'dangelor' has already helped in earlier thread.

Not tested with the CODE39 font, nor does it delete any fields after sorting...

Please Login or Register  to view this content.

Thanks once again got quick reply and code works perfectly fine, font should be "Code39 Text" i have modified it not an issue..
but please guide me how to i remove unwanted fields which are not required... please guide me i will try to work with the code.. just tell me code line for each sheet.. will try to work it out.

waiting for your reply.. buddy also if possible can you provide any source as i wanna learn this codes in excel as i work a lot with excel with data and need many more micro in similar fashion..

You can use the record macros functionality to learn some of the more simpler functions, it actually depends on what range you want to delete.

ie: if you want to delete columns T:V, use the code below

Please Login or Register  to view this content.