I need help importing from potentially every sheet in an excel workbook. First, the code has to evaluate a cell value, say A1="Y", then extract a range from that sheet. Then move on to the next, until that workbook is complete.



Then, if it can be easily done, to evaluate every workbook in a directory in that same manner. I'm kind of new to coding in Access, and I'm falling all over myself syntactically (if that is a word). Any help would be greatly appreciated.

tryingtobebetter, over and out. :?