Hi all,
I need to concatenate B and C columns in beni.xls using a VB Macro.concatenated result should be in W column.
from the sheet 1 i filter a column(Y2:AZ2) according to a date and remove the blanks from that column.
then i need to concatenate B and C columns according to the filtered column.that means i don't need to concatenate all the rows in B and C columns .i just only need to concatenate rows according to the filtered column.
as an example consider sheet 2 and 3
in sheet 2 i have filtered AG column and removed blanks.then i need to concatenate column B and C in to the column W,and other valued should not be concatenate
in sheet 3 i have filtered AL column and removed blanks.then i need to concatenate column B and C in to the column W,and other valued should not be concatenate
in this manner B and C should be concatenate in to W depending on the filtered Column
i tried it with recording a macro,but it didn't work and i don't know the reason for it.
could you please help me to find a macro which satisfy my requirement
thanks
Bookmarks