Hello Everyone,
I need some help with VBA scripting. I am trying to automate the following task
The excel spreadsheet I have has data in cells A2, B2, C2, and D2. There are many rows one below the other.
The data is as below:
A2 = Orange
B2 = New York
C2= Ferrari
D2= Summer
I need to copy the contents of A2, B2, D2 and D2 in an orderly manner on the second work sheet of the same work book as below:
On Second work sheet, Data should be only in column A and B as following with fixed titles
Fruit = Orange
City = New York
Car = Ferrari
Season = Summer
I want to keep doing this for all the rows which have data in them. Fruit, City , Car and Season will be the constant titles.
I recorded a macro, but it does the copy paste thing only for the first row.
Would appreciate if you can help me with a script that continues the process as long as there is data in the sheet1
Many Thanks!
Ajit
PS: i have provided dummy data.
I need some help with VBA scripting. I am trying to automate the following task
The excel spreadsheet I have has data in cells A2, B2, C2, and D2. There are many rows one below the other.
The data is as below:
A2 = Orange
B2 = New York
C2= Ferrari
D2= Summer
I need to copy the contents of A2, B2, D2 and D2 in an orderly manner on the second work sheet of the same work book as below:
On Second work sheet, Data should be only in column A and B as following with fixed titles
Fruit = Orange
City = New York
Car = Ferrari
Season = Summer
I want to keep doing this for all the rows which have data in them. Fruit, City , Car and Season will be the constant titles.
I recorded a macro, but it does the copy paste thing only for the first row.
Would appreciate if you can help me with a script that continues the process as long as there is data in the sheet1
Many Thanks!
Ajit
PS: i have provided dummy data.