In sheet1 x denotes rows which is dynamic and starts from 6 . so we have
D6,D7,D8... etc E6,E7.. etc
under D6 i have ABC and under E6 i have XYZ .
i have to concatenate the text in D6 with text in E6 (result shud be like
ABC_XYZ) and put it into a column B3 of sheet2 in same work book
here the rows in sheet 1 are are dynamic. so whenever an entry happens in
sheet 1 , the text in the two columns should be concatenated and put into
sheet 2 column.
so wat VBA code do i write to concatenate and copy into sheet2