Hi, Murtaza. I had a similar situation in one of my workbooks, and I used
the following macro to accomplish this task:
Sub CensusLink()
' Keyboard Shortcut: Ctrl+c
'
Selection.Copy
Sheets("Source").Select
ActiveSheet.Paste Link:=True
ActiveCell.Offset(1, 0).Range("A1").Select
Sheets("Target").Select
ActiveCell.Offset(0, 1).Range("A1").Select
End Sub
You will need to edit the "Source" and "Target" sheet names with the
respective names of your own sheets. Make sure you have the cursor
positioned in the first cell of the target sheet where you want the first
data item to be copied. Then go to the source sheet and place the cursor in
the cell containing the first item to be copied. Now hold down the Ctrl key
and press c however many times to copy the entire row to the column on the
target sheet. For a large row of data, you can just hold the c key down,
and it will run the macro repeatedly and very rapidly. But if you overshoot
the range, you can always go back to your target sheet and delete the
results of the extra runs. Hope this helps.
Larry