This site under reconstruction.
It seems to me that every Monday now, my macro no longer works in the office. Outside of the office, such as my home or the hotel, the program works. This past Monday, it started out with my inability to access the internet. My machine just would not go to our vendor’s site that we…
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…