vba code or formula assistance to associate a date, text, and value to a summary report.

**lilsnoop** · 12-31-2012, 05:28 PM

Hello, I tried searching the web for anything remotely close to doing this.. so I'm skeptical this can be done. With that said though, I thought before giving up I'd ask for any assistance or insight one could give from the forum.

I'm looking for a formula or vba coding that would look at the filtered name in column "A" then from row 1 between Columns C through Q in this sample workbook identify the date range and then starting with row 5 look for any of the following codes "8S", "7S", "6S", "5S", "4S" , "3S",, "2S", "1S" and associate them as one group . Ideally, I would like to assign a value to these codes ; i..e. "8S" = 8, "7S"= 7, etc and then via the formula have a result something to the effect below: (also I'd like this to populate on another sheet tab titled Report.

End result looking something like this:

John Doe,
Wednesday, 01/02/2013 4S, 4 hrs
Thursday, 01/10/2013, 8S, 8 hrs.
Total: 12 hrs.

If this is possible, your assistance would be greatly appreciated!

**rcm** · 12-31-2012, 07:53 PM

try this macro

**lilsnoop** · 12-31-2012, 08:37 PM

Nice rcm! I've plugged your code into my full workbook and it seems to only do two names in my name list summary report and not the 36 that are in column A. I was curious if I could limit the summary report to only locate files with a number and an "S" in it; i.e. 7S, etc. So it wouldn't necessary identify a coding that would reflect "SW", etc. Thanks so much for your efforts and time!

**rcm** · 12-31-2012, 09:53 PM

I limited to lines 5 and 6 but it can be set from 5 to range("a"&rows.count).end(xlup).row too

**lilsnoop** · 12-31-2012, 10:58 PM

Thank you that did do the trick. Any way to limit it to just find and add the following "8S, 7S, 6S, 5S, 4S, 3S, 2S, 1S" ? Thanks so much for your help! I'm very pleased with your code!

**rcm** · 01-01-2013, 08:54 AM

There you go, the filtering assumes that the length is 2 and ends with an "S"

**lilsnoop** · 01-01-2013, 10:52 AM

Thanks a lot rcm! That last example did just what I needed! Your help was greatly appreciated!!

vba code or formula assistance to associate a date, text, and value to a summary report.

LinkBack

Thread Tools

Rate This Thread

Display

vba code or formula assistance to associate a date, text, and value to a summary report.

Re: vba code or formula assistance to associate a date, text, and value to a summary repor

Re: vba code or formula assistance to associate a date, text, and value to a summary repor

Re: vba code or formula assistance to associate a date, text, and value to a summary repor

Re: vba code or formula assistance to associate a date, text, and value to a summary repor

Re: vba code or formula assistance to associate a date, text, and value to a summary repor

Re: vba code or formula assistance to associate a date, text, and value to a summary repor

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions