hello
I have some files names in multiple sheets and in multiple columns
begins from COL A but the end the columns should be dynamic
not end to specific columns the files are existed in this directory "C:\Users\ORLAD\Desktop\ff" and the files names are existed in
all the sheets brings by another macro and this directory has many subfolders and different files in extensions so what I want when put the file name in SHEET SEARCH in cells c3 should move and active this cells in specific sheet and highlight by blue and show message to open the file if press ok then open the file and delete color cell which highlighted and if press no then just stay highlight the cells and if I move to sheet SEARCH also delete the color
keep in your mind every time I create a new sheets and a new subfolders and files and increase the columns when add files names then should the code are dynamic
if anybody needs some more explanations please tell me
by the way I issue this thread in another forum and no body answers me so far
search files across multiple sheets based on cell value and highlighted
I have some files names in multiple sheets and in multiple columns
begins from COL A but the end the columns should be dynamic
not end to specific columns the files are existed in this directory "C:\Users\ORLAD\Desktop\ff" and the files names are existed in
all the sheets brings by another macro and this directory has many subfolders and different files in extensions so what I want when put the file name in SHEET SEARCH in cells c3 should move and active this cells in specific sheet and highlight by blue and show message to open the file if press ok then open the file and delete color cell which highlighted and if press no then just stay highlight the cells and if I move to sheet SEARCH also delete the color
keep in your mind every time I create a new sheets and a new subfolders and files and increase the columns when add files names then should the code are dynamic
if anybody needs some more explanations please tell me
by the way I issue this thread in another forum and no body answers me so far
search files across multiple sheets based on cell value and highlighted