Hi all! This forum has been a great help in the past and I've lurked here soaking up as much as I can. Alas, I've come to a problem that requires me to become active and thus, my first post!

What I'm trying to accomplish:

I've been asked to collect up data points, we'll call them "values" from a collection of Excel files scattered throughout a maze of folders on our network. The naming convention for the files do not follow any specific pattern, but, and here hopefully is the saving grace, the Worksheet within each file does follow a standard naming convention.

Location: G:\Data\Notes
Worksheet name: Data Values
Data Location within Worksheet: Column B (text), Column C (value).
Output: Two Columns (Column 1 (text), Column 2 (value))

A few challenges/questions: Is there a way to ignore any text that is BOLD? The text elements in Column B that I would like to ignore are bold. I would prefer to only return text and their cooresponding values that are not bold. If not, I can work around this by simply removing any rows from Column 1 where Column 2 returns no value (null).

Please let me know what other information you need from me. And most of all THANK YOU for providing such a wonderful resource for those of us still learning.

Bests,