I have set of records in sheet name as "Copydata" from c5 eg:- (UPE3-QUBBKHAB-1,UPE3-SENAJZAI-1,UPE3-109-00-303-1), here the records may be from c5 to c10 or ct to c7 or c5 to c3.
I have another sheet as "List" were have all the records from c5
I am not sure, as will autofilter works with multi pal criteria
I mean from copydata sheet VBA should search all the records from c5 till the end and autofilter the same in sheets List from c5 till end of record.
then copy and paste the visible cells in Manual Email sheet from a5 copy paste should be one below the other.
if any record is not available from Copydata list it should show as no data from sheet List found.
Any Idea, as I don't have any way to work on arrays.
I have another sheet as "List" were have all the records from c5
I am not sure, as will autofilter works with multi pal criteria
I mean from copydata sheet VBA should search all the records from c5 till the end and autofilter the same in sheets List from c5 till end of record.
then copy and paste the visible cells in Manual Email sheet from a5 copy paste should be one below the other.
if any record is not available from Copydata list it should show as no data from sheet List found.
Any Idea, as I don't have any way to work on arrays.
