Im newbie here and hoping you could help me also with my inquiry.
Sheet1
Column A Column B
Name Juan dela Cruz
Age 21 yrs old
sex male
Sheet2
Column A Column B column c
Name Age sex
Juan dela Cruz 21 yrs old male
This what I want to do In sheet1 i will input name and age
When running the macro this data will add to sheet2
as shown above, however when I input new name this will not
continue to the next row instead the new name will just replace to previous one....
below is my recorded macro..
Sheet1
Column A Column B
Name Juan dela Cruz
Age 21 yrs old
sex male
Sheet2
Column A Column B column c
Name Age sex
Juan dela Cruz 21 yrs old male
This what I want to do In sheet1 i will input name and age
When running the macro this data will add to sheet2
as shown above, however when I input new name this will not
continue to the next row instead the new name will just replace to previous one....
below is my recorded macro..