khalid79m
01-02-2009, 05:55 AM
Hi I have a list of file names in column a. eg of file names
Cairo_CM_DDA_Micheal Smith_RSSv1_12_2008.xls
London_CM_DDA_Joe Smith_RSSv1_12_2008.xls
Manchester_CM_DDA_Arnold John_RSSv1_12_2008.xls
NewYork_CM_DDA_Liam Noel_RSSv1_12_2008.xls
Dehli_CM_DDA_Micheal Jordan _RSSv1_12_2008.xls
Oxford_CM_DDA_Andrew Netto_RSSv1_12_2008.xls
Cairo_CM_DDA_Micheal Smith_RSSv1_11_2008.xls
London_CM_DDA_Joe Smith_RSSv1_11_2008.xls
Manchester_CM_DDA_Arnold John_RSSv1_11_2008.xls
NewYork_CM_DDA_Liam Noel_RSSv1_11_2008.xls
Dehli_CM_DDA_Micheal Jordan _RSSv1_11_2008.xls
Oxford_CM_DDA_Andrew Netto_RSSv1_11_2008.xls
For each file name in column A I want to put in column B "PASS" or "FAIL",
For the file to pass it must
contains the word in Sheet Control_Panel $A$1 & $B$2
please note curently in Control_Panel $A$1 = 12 & $B$2 = 2008 so the pass results would be
Cairo_CM_DDA_Micheal Smith_RSSv1_12_2008.xls
London_CM_DDA_Joe Smith_RSSv1_12_2008.xls
Manchester_CM_DDA_Arnold John_RSSv1_12_2008.xls
NewYork_CM_DDA_Liam Noel_RSSv1_12_2008.xls
Dehli_CM_DDA_Micheal Jordan _RSSv1_12_2008.xls
Oxford_CM_DDA_Andrew Netto_RSSv1_12_2008.xls
I hope this is clear, please contact me if you have any question, im really struggling with this one...:help
Cairo_CM_DDA_Micheal Smith_RSSv1_12_2008.xls
London_CM_DDA_Joe Smith_RSSv1_12_2008.xls
Manchester_CM_DDA_Arnold John_RSSv1_12_2008.xls
NewYork_CM_DDA_Liam Noel_RSSv1_12_2008.xls
Dehli_CM_DDA_Micheal Jordan _RSSv1_12_2008.xls
Oxford_CM_DDA_Andrew Netto_RSSv1_12_2008.xls
Cairo_CM_DDA_Micheal Smith_RSSv1_11_2008.xls
London_CM_DDA_Joe Smith_RSSv1_11_2008.xls
Manchester_CM_DDA_Arnold John_RSSv1_11_2008.xls
NewYork_CM_DDA_Liam Noel_RSSv1_11_2008.xls
Dehli_CM_DDA_Micheal Jordan _RSSv1_11_2008.xls
Oxford_CM_DDA_Andrew Netto_RSSv1_11_2008.xls
For each file name in column A I want to put in column B "PASS" or "FAIL",
For the file to pass it must
contains the word in Sheet Control_Panel $A$1 & $B$2
please note curently in Control_Panel $A$1 = 12 & $B$2 = 2008 so the pass results would be
Cairo_CM_DDA_Micheal Smith_RSSv1_12_2008.xls
London_CM_DDA_Joe Smith_RSSv1_12_2008.xls
Manchester_CM_DDA_Arnold John_RSSv1_12_2008.xls
NewYork_CM_DDA_Liam Noel_RSSv1_12_2008.xls
Dehli_CM_DDA_Micheal Jordan _RSSv1_12_2008.xls
Oxford_CM_DDA_Andrew Netto_RSSv1_12_2008.xls
I hope this is clear, please contact me if you have any question, im really struggling with this one...:help