NICOP Procedure Online -Overseas ( Dubai ) resident guide

NADRA Provide us a very good facility to get NICOP at your door step. Here I am sharing my experience  how I obtained NICOP in only 15 days at my door step in Sharjah. Below is the procedure :

1)Goto to Nadra website Click here .
2) Now Register  By Clicking on Register An Account 

3)Now fill the form and continue

4)Now  after login you will see terms and condition page and the below page will visible. Click on Go to identity M

5) Now Click on New Application 

6) Now follow the steps 

7)Fill all the information name , address etc.

8) Upload documents photo with white background , passport scan copy, NIC scan Copy , Marriage certificate (if married of course :)) and birth certificate as I have modify my birth place destrict .

9) You need 2 reference of any friend so you need their Id card number

10) For you finger prints you have to fill finger print form that form have tracking Id where 

Sample finger print form can be downloaded from Nadra's Download page or click here  

11)Now Print out finger print form and using black stamp pad put all the finger prints on mentioned boxes in the form.

12)Now Scan this finger print form  , while scanning you must select 600 DPI and grey scale option that is available in scanners option. If you not chose these options your form will not be accepted.

I have paid 6400 rupees by credit card 5400 is the fees and 1000 is delivery fees for Sharjah/ Dubai and received my NICOP in 15 days.

Summary of the Process :

Click on the green Get Started button at the top to launch the Pak-Identity Application System

Register your account there

Create an application in the appropriate category

Provide details for the following:

• Personal
• Spouse / Parents
• Relatives

Scan and upload your photograph Must be white background

Scan and upload the supporting documents like passport, birth certificate etc

Download and print the  fingerprint form on A4/Letter page size.

Capture your fingerprints on this form with the help of the Fingerprint guide available in nadra page.

Scan and upload the fingerprint form.

Scan quality must be a minimum of 600 dpi in Grayscale.

Review the information you provided and sign the declaration.

Provide your address for card delivery.

Pay application fee online with your Credit Card/Debit Card.

Now wait in 15 days you will get the Nicop in your door step :)

Procedure To Renew Pakistani passport in Dubai UAE ( 7 March 2016 ) Latest

You can renew your pakistani passport from pakistani consulate located in Bur-Dubai Khaleed bin waleed road near Burjuman Shopping Mall :

Here is the Google Maps location 

Try to reach as early as possible around 7:00 am is better sometimes they stop providing token after 11 . If you have family you will complete the procedure very soon because there is a separate lines for ladies.

Documents Required For Pakistani Passport Renewal in Pakistani consulate Dubai :

Original Passport.

Original CNIC or NICOP.

Copies of passport, Visa and CNIC.

Passport Renewal Fees / charges :

5 year expiry
151 AED for normal process ( It will take around 25 days) 
251 AED for urgent process ( It will take around 10 days )

10 year expiry :

272 AED for normal process ( It will take around 25 days) 
452 AED for urgent process ( It will take around 10 days )

Procedure :

1. From main gate there is a token machine get Token number and wait
2. Bank Counter: Fee payment at Bank counter
3. Token Counter: Photo capturing and issuance of computerized token
4. Bio Matric Counter: Thumb Impression
5. Data Entry Counter: Data acquisition by DEO
6. Decision Counter: Form Submission at Passport Decision counter.

Passport collection :

You can collect your passport from Pakistan consulate on the date written on slip and don't forget to bring your old passport when your are going to collect your new passport.

Or 

You can go to TCS counter and counter 10 where they will take your old passport and slip and their charger around 10 to 15 AED and deliver your passport at your door step .

Parking :
In the morning you will find paid parking their but not too much and after 10:00 am there will be very difficult to find parking .
Parking zone Number is 134A near Pakistan consulate you can send SMS to 7275 along with your plate number and hours like this   plate_no 134A 1 and send it to 7275

Highlight Active Cell in MS Excel 2007

It is a very common problem that during presentation of any MS excel File we want to highlight active cell. There is some modules available but they might affect the format of your sheet.By adding this module to your sheet you can minimize this problem for example if you want to highlight the cell where you are working  as shown in figure1. 

for adding this feature to your excel sheet follow the steps Given below.

Step 1: Press ALT + F11 you will get the following screen

Step 2:Now Double Click on this Workbook and add following Module :

' Author Naushad Qamar
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
On Error Resume Next
Static OldRange As Range
Static OldIndex As Integer
Const movingColor = 6
If OldRange.Interior.ColorIndex = movingColor Then
OldRange.Interior.ColorIndex = OldIndex
End If
OldIndex = Target.Interior.ColorIndex
Set OldRange = Target
Target.Interior.ColorIndex = movingColor

End Sub

Step3:Now open your worksheet you will find active cell highlighted..

Step4: Now save File as Macro enabled as shown in figure :

Working sample Download
Please Do Comment and  give suggestions, moreover if you have any query,  feel free to ask.