drives

I'm not sure this is possible, but I thought I'd ask! Currently have a summary sheet that we have to manually change each day as a new sheet is added - the input is the name of that new sheet, and it drives an indirect formula. Its not a major pain but I wondered if I could automate this...

Hi all, Here is a way to display long statements in any Excel rows instead of using merged cells. It works perfectly ''horizontally'' Does anyone know how to adapt it ''vertically'' ? It drives me crazy ... :( Here is the link...

So, my place of employment has decided to do away with local network drives, and to migrate all files on these drives to SharePoint. Seems like a good idea. I like the flexibility and security of sharepoint. My issue is that I have quite a few workbooks that reference other workbooks for data...

Hi All, Could please someone help me with some formula? It drives me crazy since days/weeks. I would like to do the following but dont even have an idea how to describe it :D Count "A" until there is "B". Stop countung "A" but start count "B". If there is "A" again start over but add 1 to the...

Is it possible to have vba search through all mapped drives for a file name and open that file? I am trying to make a previously written code bullet proof by giving the users the ability to have a file that the macro uses saved anywhere rather than force them to remember to save it to a...