Attendance calculation, Excel Macro

**twsit** · 11-03-2008, 12:26 PM

I need help with an excel macro that will take a username (string) in the first column and look at everytime that they either have an P (present), T (tardy), E (Excused), or A (absent) in a second column. They will be given 400 points if they were present every time, but for every T (10 points), A (60 points), E (25 points) will be deducted from their original 400 point score. Any help would be aprreciated, I don't know where to start.

**stanleydgromjr** · 11-03-2008, 01:15 PM

twsit,

Please attach your workbook.

Have a great day,
Stan

**royUK** · 11-03-2008, 01:28 PM

twsit, welcome to the Forum.

Please take a few minutes to read the Forum Rules then edit your post's title. Thanks

**twsit** · 11-03-2008, 05:14 PM

Attendance Example.xlsx

Here is example, I have a nice formula that works in excel, but I want to make a macro to make things a little faster.
Thanks

**VBA Noob** · 11-03-2008, 05:16 PM

twsit,

Please do change the title otherwise I will close this thread

VBA Noob

**twsit** · 11-03-2008, 05:39 PM

There you go, is this one better.

**VBA Noob** · 11-03-2008, 05:44 PM

Nope. To vague and not related to the problem

VBA Noob

**stanleydgromjr** · 11-03-2008, 10:48 PM

twsit,

make a macro to make things a little faster

Nice formula.

Please explain how you want to make things a little faster?

Have a great day,
Stan

**twsit** · 11-04-2008, 02:45 PM

so i don't have to copy and paste cells to the right of information that angel (a online class website) spits out for me into an excel worksheet I can just run a macro and it will do the calculation for me and spit it out, this will not save much time, but enough when your dealing with a lot of classes.

Attendance calculation, Excel Macro

LinkBack

Thread Tools

Rate This Thread

Display

Attendance calculation, Excel Macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions