Copy Data from one column in a sheet to another column present in 2nd sheet

Do you have a sample file that you can attach? I am not able to understand without it.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Regarding your question 1, in sheet "def", cell D2, enter this formula

Formula:

Please Login or Register  to view this content.

Drag it down to 100 or how many ever rows you need.

I am not able to understand your question 2 at all.

Happy independence day to all.

Thanks for reply.

the formula you have given is just copying the values in A2 to D2 to Dn where n is the no of rows i need to copy but , i want a formula by which i can copy what is wriiten in An to Dn Where n=2,3,4,.....1000.i.e. A2 to D2,A3 to D3,etc.

the second question is ,look at the every ID column. there i want that Title Id must be automatically 2 if any new row is created and only when Title is entered. similarly after it ,in the same row if any item(question,Answer) is entered , ID column with that item must be incremented by previous ID +1.

please go through the newly provided excel sheet .