Here is my recommendation when it comes to learning VBA or any language for that matter.

All computer languages have functions, methods, variables blah blah blah. What I have found is that you need to program your mind first before programming starts to make sense. Here is my suggestion on what you should learn for VBA and in what order.

1. Macro recording (Start using the macro recorder to do simple operations then look at the code after. Trust me a lot of it wont make sense but some will.
2. Write your first msgbox macro Something simple like
sub boxxy ()
msgbox "Hi there everybody"
end sub

You will notice on the msgbox when typing that it will show you alot more things you can enter. Here is a hint if those things are in [square brackets] they are optional.
3. write your first inputbox macro (Very similar to msgbox)
4. Start understanding variables and datatypes. There is a ton of info out there on these. Use simple ones like strings and integers to begin with.
Example
dim boxxy as string
boxxy = "Here is a message boxy from boxxy"
msgbox boxxy
end sub

5. once you have variables down a little bit start writing if statements. Try it with an input box and a message box.
Start with
sub boxxy ()
dim boxxyPrmpt as integer
boxxyStr = "message 1"
boxxyprmpt = inputbox("Enter a number from 1 to 100")

if boxxyPrmpt > 50 then
msgbox "Higher than 50 entered"
else
msgbox "Less than 50 entered"
end if
end sub

You can even declare 2 more string variables and assign them to the 2 msgbox's

6. Loops learn the For (stands for "For this instance") and Do You will also need to understand the range function and maybe cells
research these and let us know what you run into.

It goes slow at first but gets a lot easier as you go.

Okay I think i got it all figured out. Take a look guys and let me know what you think.

Jonathan

2013 Membership Attendance.xls

Looks right to me, Jonathan. I expected you to expand downward; it didn't occur to me to expand to the right, but what you have should work perfectly.

I did initially expand downward, but when I printed it out I didnt like the look of it, so I decided to go sideways.

Do you think you could walk me through how to do the part you talked about where instead of entering a date, when i hit the populate report button it just goes based upon whatever column it is in.

Real interested in how to make that function.

Jonathan

Yes, I can! I'm glad you asked. Um...would you rather switch to email? It might be easier, especially if we're going to start using screen shots; and I'm not convinced this will be of general interest to anyone else. (If anyone else wants to see this, speak up.) If you want to contact me directly, I'm at robhbridges (at) gmail.com.

Yeah switching to email would be a lot easier for me.

Jonpackbosoxfan@gmail.com