Skip to main content

Excel Macro which copies one column to another by matching specific unique column

This is a simple Excel Macro which copy one column to another by comparing specific unique column. There two sheets: Sheet1 and Sheet2. We copy column 2 and 3 at Sheet2 to column 2 and 3 at Sheet1 by matching column 1 at both.

There might be persentage data. You should use NumberFormat parameter in that situation.

Sub CopyCells()
    '*** Defining variables ***'
    Dim Value1, Value2
    Dim RowsCount1, RowsCount2

    '*** Find out rows count ***'
    RowsCount1 = Worksheets("Sheet1").Range("A1").CurrentRegion.Rows.Count
    RowsCount2 = Worksheets("Sheet2").Range("A1").CurrentRegion.Rows.Count

    '*** Copying data ***'
    For C1 = 2 To RowsCount2
Set Value1 = Worksheets("Sheet2").Cells(C1, 1)
For C2 = 3 To RowsCount1
Set Value2 = Worksheets("Sheet1").Cells(C2, 1)
If Value1 = Value2 Then
                Worksheets("Sheet1").Cells(C2, 2) = Worksheets("Sheet2").Cells(C1, 2)
                Worksheets("Sheet1").Cells(C2, 2).NumberFormat = "0.00%"
                Worksheets("Sheet1").Cells(C2, 3) = Worksheets("Sheet2").Cells(C1, 3)
                Worksheets("Sheet1").Cells(C2, 3).NumberFormat = ""
            End If
        Next C2
    Next C1
End Sub

C1 and C2 mean Counter1 and Counter2.

How to synchronize Google Calendar and Outlook?

If you want to sync Google Calendar and Outlook, Google Calendar Sync tool is all you need. There are 2-way and 1-way synchronizing alternatives. Try it:

http://dl.google.com/dl/googlecalendarsync/googlecalendarsync_installer.exe

Google Calendar Sync tool

If you have Google Apps for Business (I mean you pay for the service), you can use an excellent tool that name is Google Apps Sync for Outlook. It provides mail, calendar, contact, free/busy data syncronization capability.

http://www.google.com/apps/intl/en/business/outlook_sync.html

Lastly, if you are bored of Outlook (How can it be possible?!) and want to move whole data to Google Apps, Migration Tool is for you:

http://tools.google.com/dlpage/outlookmigration

How domain names expire?

What do “Domain Name Status Codes” mean?

You might have diffuculty understanding domain name status codes because there are quite a lot of codes. Look at the list and figure.

  • ACTIVE: A domain can only be modified by the domain registrar.
  • REGISTRY-LOCK: The domain can not be modified or deleted by the registrar. The registry must remove the REGISTRY-LOCK status for the registrar to modify the domain.
  • REGISTRAR-LOCK: The domain can not be modified or deleted. The registrar must remove REGISTRAR-LOCK status to modify the domain.
  • REGISTRY-HOLD: The domain can not be modified or deleted by the registrar. The registry must remove the REGISTRY-HOLD status for the registrar to modify the domain.
  • REGISTRAR-HOLD: The domain can not be modified or deleted. The registrar must remove REGISTRAR-HOLD status to modify the domain.
  • REDEMPTIONPERIOD: The registry sets this status when a registrar requests that the domain name be deleted from the registry and the domain has been registered for more than 5 calendar days (if the delete request is received within 5 days of initial domain registration it will instead be deleted immediately). The domain will not be included in the zone. The domain can not be modified or purged; it can only be restored. Any other registrar requests to modify or otherwise update the domain will be rejected. The domain will be held in this status for a maximum of 30 calendar days.
  • PENDINGRESTORE: The registry sets this status after a registrar requests restoration of a domain that is in REDEMPTIONPERIOD status. The domain will be included in the zone. Registrar requests to modify or otherwise update the domain will be rejected. The domain will be held in this status while the registry waits for the registrar to provide required restoration documentation. If the registrar fails to provide documentation to the registry within 7 calendar days to confirm the restoration request, the domain will revert to REDEMPTIONPERIOD status. The domain status will be set to ACTIVE only if the registrar provides documentation to the registry within 7 calendar days to confirm the restoration request.
  • PENDINGDELETE: The registry sets this status after a domain has been set in REDEMPTIONPERIOD status and the domain has not been restored by the registrar. The domain will not be included in the zone. Once in this status all registrar requests to modify or otherwise update the domain will be rejected. The domain will be purged from the registry database after being in this status for 5 calendar days.
How domain names expire?
How domain names expire?

Source: http://www.registercompass.com/wiki/domains/pendingdelete.aspx