You are reading a single comment by @Olly398 and its replies. Click here to read the full conversation.
  • Looks like a good page on it here: http://www.cpearson.com/Excel/foldertree.aspx

    lists the... worksheets and the bottom used cell for each sheet

    In order to do this you would need extra code to open, extract data and close each, which could be a long process.

About

Avatar for Olly398 @Olly398 started