Home / Archive by category "Excel"


Using a macro to help me review data

New Idea - Using Macro as Guide to Review Data
[Yesterday I was going to do a post but Microsoft had other ideas for me. It turned out they hadn't finished updating my machine last week so last night I had to let it finish the update. Besides WordPress was telling me that I did not have the latest version of Microsoft Edge. Unfortunately, by the time Microsoft finished the update, it was time for me to wrap up and get ready for bed.]...
Read More

Experimenting with Heat Maps

Research data - attempting to do analysis by using a form of heat map
I tried to do this post this morning but my machine wanted to do something else: either Apple was trying to push something or my security software wanted to do some updates. I can't tell which was preventing me from doing anything, either going out to the Internet or shutting off my machine. So I let the machine spend a couple of hours doing what it wanted to do and I initiated my securi...
Read More

Two topics: hurricane weather and the need to double check your Excel results.

This post is going to be very short because I have a headache, probably from lack of sleep over worry about this storm. We're supposed to have tremendous amount of flooding over the weekend - between 15 -20 inches.  The weather is coming in via hurricane and it is supposed to stall in our area for three or four days. Being stationary for that length of time means a potential for catastro...
Read More

Listening to My Customers

Listen and Collaborate
We're on our third year with our automated operational reporting, which has been rolled out to both sides of the house. It kind of gives me a secret thrill to think that once a week, everyone comes in to work in the morning, opens up the file and lets the program do its magic. And if they have done what they needed to do during the past week, the report is done in about five minutes. Now...
Read More

New Idea: A self-correcting Excel file

Exploring a New Idea
I did something I have never seen done before: I created a self-correcting spreadsheet. In the last few weeks I've been working on generating a solution to pull together and print out state government regulations, covering certain topics such as minimum wage, meal and rest breaks, overtime, etc. My company probably pays to receive this data from another company and the data comes in down...
Read More

Automatic Printing to PDF: Challenges with Repeating Headers and Page Breaks

Special Printing from Excel
So far, on this latest project, I have figured out how to handle varying spelling of state names when a normal VLOOKUP or pivot table won't do. And I got through the issue of varying row heights in the downloads. The posts can be found below and each contains a copy of the Excel file so I won't rehash those:A Solution for Looking Up Things When a Simple VLOOKUP Won't DoPart 2 of Using Ar...
Read More