search files names across multiple sheets based on cell value and highlighted

leap out

Board Regular
Joined
Dec 4, 2020
Messages
151
Office Version
  1. 2016
  2. 2010
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,141,875
Messages
5,709,113
Members
421,616
Latest member
Rachy_bo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top