Hi Guys you can take me as New in Micros but heard Micros do lots of magic stuffs in Office 2007.
Well I am into eCommerce Business and need to print lots of Label but first have to search for Serviceable Pincode for Different Courier Service.
I use 3 Couriers Service "DTDC" , "ARAMEX" & "DHL-Bluedart".
Hence have 3 Excel File with List of PINCODE (Country Code) which i have to search individually in each Courier Service File and return back to my Label Data and assign which Service to use for each labels.
What i am exactly looking for is some micro in which i type in the pincode (6 digit for India) and the pincode is searched into 3 excel file which contains the list of pincode if the pincode is available it should return that file name. If the pincode is available in all 3 excel file should display all 3 names so i come to know that this pincode is serviceable with all 3 courier service.
Or we can also do like make 1 excel file with 3 sheet of 3 couriers, somthing like that if it works..
If the above stuff sounds confusing please let me know i can explain in detail as well...
hoping to hear from you guys soon...
Bookmarks