hi all,

Query 1)

sheet "abc"

ex:
A B C D E F G H I J K L M N O
1 Title | id | Question | id | Question |id | Question | id | Links | id | Links | id | Links | id |
2 hi 2 u dere? * Are You Serious? * ok *
3 a 2 b * Q1 * Q2 * ok * ok2 *


i want a macro code for copying a particular column values from one sheet to another sheet .

suppose i have 1st sheet with name "abc". there i have a column whose "A1" is the column whis is having "Title". i want to copy the entire column till values have been entered to next sheet named "def" column "D1" which is having heading of "tiltename". i want that whenever user enter the title in sheet "abc". the "D1" in sheet "def" gets populated from "A1".

Query 2)

i want a macro code for automatically incrementing of values in sheet "abc" in every row where if user enters title id must be 2 after it every item if present then *=previous id=id+1;

that is, in ex ,in first row, u dere? has id=2+1=3 and are you serious has id 3+1=4 but ok has id= 4+1=5 as another question is not present.

title must have fixed id=2, but after only things having some values have the id which should be previous item's id +1;