This site under reconstruction.
My usual macro that I use to collect Excel files into a summary report failed me on Monday. But someone else could use the macro which told me that the problem was with my machine, not the macro.This post will be short since it is late but I do want to point out some steps…
This week was another one of those discouraging week – I couldn’t really solve anything useful and everything takes me so long.I keep encountering the need to create a list of the most common phrases – not words, phrases – such as unit names or vendor names, etc. Every time I do a data download,…
At work, I’ve been working on sifting through data to see if there is anything we should be aware of or could use. I’ve encountered some new kinds of problems on arranging the data, so I’ve been Googling a lot lately. These Googles have led me to an interesting page at Exceljet that shows some unusual…
The last post discussed the high level mechanics of setting up formulas to check for hard coded numbers. I ended with a comment about doing this check for 64 files and mentioned that a macro would needed to be done to do this kind of check.Today, this post will show the macro. The last post…
Aaarrrggghhh!!! She overwrote the formulas with hard coded numbers and now the math is not working. She has left for a position that has better growth potential and I am happy for her. So I took back the automated reporting that she was handling. She was actually doing it very well, but I must remember…
Some people get ideas while taking a walk or while in the shower. I get ideas when I’m driving. After driving a while, I start to kind of daydream, going over in my head the events of the day or describing what I’m doing and why I’m doing it. The daydreams are typically little conversations…