Macro Work

In the late 80s I had some interest in computer and took one course at a time to complete a computer applications occupational certificate at a local community college. Part of the program included a course in flow charting and two classes in programming. The spreadsheet class (remember Lotus Notes?) included macros. I liked the logic and structure of programming in the little things we did in class.

Fast forward to about 2005 when I worked in an accounting department. One of the team leaders in the department knew that I had a small knowledge of macros and gave me various macro writing projects over the course of next 3 years. There were others available to go to with questions and a previous employee had made a rather extensive spreadsheet of common macro commands. When I didn't know how to do something I could search on-line to find the commands and steps needed. I often went to the same websites for help.

In 2011 I went to another job where I reported to the manager from my previous company. She gave me several more macro projects in the year we worked together there.

Now I'm not in an accounting department, but at a recent department lunch a co-worker was telling about copying and pasting 8 numbers from one spreadsheet to another and had to do each number individually for what was going to be up to 100 people or so. Another person thought I could do something for her so I started in on another macro project.

I am not fast with my programming and people who really know macro programming would probably look at what I do and think "What is she doing?????" However, it works.

Today I gave my co-worker the finished product. What would have taken her well over an hour now completes in about 15 seconds. The macro copies all the numbers and then color codes them red, yellow, or green for unacceptable, ok, and excellent. She said she never would have dreamed of the color coding so that far exceeded what she wanted.

It is fun to help others be more efficient. It is also interesting to see how what I did 25 years ago and people who influenced me during that time helped make me successful now.

Thankful Thursday 09/19/13

1. Mowed the yard for the first time in sub-90 degree temps. It was still hot.

2. Received some very nice recognition at work this week. Renae asked if we get more than just an "attaboy" when we get recognized in various meetings. I said no, but then added that an 'attaboy is more than you get at many places.

3. Had a great time last Friday morning reconnecting with Reach Out Reach Up, an early morning prayer group for those looking for work that I participated in for 4 months.

4. Having fun working on a macro at work. My macro work is very basic I'm sure, but it is fun for me.

Thankful Thursday 09/12/13

1. Loving my job. It's so nice to be affirmed for my work including being praised for contributions that I wouldn't have considered my strengths.

2. A work team leader who is willing to share with others that ideas came from other people than him.

3. Having a cafeteria at work. The food is excellent and the staff is very, very friendly.

4. Having a parking garage which helps keep the car cooler in the heat of 100+ degree days.

5. BSF started on Monday night. I'm really looking forward to studying the book of Matthew this year.

6. Doing a Thankful Thursday means tomorrow is Friday and the last day before the weekend.