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
You have already got a formula in column W, why do you need a macro for? What is not working in a formula?
i want to automate this task.selecting and filtering the column according to the date also a automated task(i already have a macro for this).
after concatenated I'm going to vlookup those valued with another sheet.
i tried with a recorded macro,but it doesn't work with any filtered column ,
thanks for the comment