My problem explanation is:
I have to match the column A values(IMP_Plad_BF3 etc.) in Worksheet 'WS Groups' with multiple Column values in Worksheet 'references'. Once a match is found I have to look for a String "WS Group Totals:" in column B of Worksheet 'WS Groups'. Once the string is found I have to copy the entire range of rows from column A match to Column B match and paste it in a separate Worksheet based on the 'Reference' Worksheet column names.. I have written the code .... my only problem is when I am trying to match the column A values in 'WS Groups' worksheet to multiple column values in 'References' worksheet and if there are no matches found then I have to copy the block to a worksheet named 'Not in reference table', but I am not able to do that...one thing is I should match column A values like (starting with IMP_, and not the ones starting with 6_3 )..I have included my workbook with the code and below I have put the code where I am having problems..please help somebody..... couldn't post the entire code below cos of restriction and so please find the full code in the workbook attached..thanks....
where my dobut is (Excel help forum please look this block of code)
Bookmarks