jg_prasad
01-19-2012, 07:07 AM
Hi,
I have two columns (A, B) with header columns as "History" and "Update" respectively.
"History" header has active rows with different data in different cells.
"Update" header also has active rows with different data in different cells.
I want to insert contents of individual rows of B into it's adjacent rows of A without overwriting the existing contents of A. This should happen for all rows in the worksheet. I am looking for vba macro for this.
The resultant A (new A) should be something like this...
"TODAY(DD-MM-YYY)+B2's content+char(10)+A2's content"
Expecting it to get autopopulated for all rows in a similar fashion whenever I run macro.
Can you help.
Thanks,
Prasad
I have two columns (A, B) with header columns as "History" and "Update" respectively.
"History" header has active rows with different data in different cells.
"Update" header also has active rows with different data in different cells.
I want to insert contents of individual rows of B into it's adjacent rows of A without overwriting the existing contents of A. This should happen for all rows in the worksheet. I am looking for vba macro for this.
The resultant A (new A) should be something like this...
"TODAY(DD-MM-YYY)+B2's content+char(10)+A2's content"
Expecting it to get autopopulated for all rows in a similar fashion whenever I run macro.
Can you help.
Thanks,
Prasad