Populating a list with a macro based on inputs

Hi all,

I've attached a spreadsheet that pretty clearly shows my challenges. I got sheets one and two figured out, but sheet 3 remains beyond my skill set.

Sheet1: Data on calls detected
Sheet2: Using alot of CountIfs and text strings, counts out how many calls are detected in each 10 minute increment of any given day, as determined by cell A2.
Sheet 3: Supposed to manipulate the date on sheet two, record a value (total calls as of now) from sheet 2, and report it to sheet 3. Then loop for all the days in the data set (or a given list).

So, any help would be appreciated, I'm very new to VBA macros.

EDIT: I had to shorten the data sheet to make the upload size limit, so there are only calls for the first 12 or so days...

Thanks,
Abe Borker
UCSC Center for Ocean Health
Santa Cruz, CA

HI

You should be able to use a countif function based on the data from sheet 1,

e.g. =COUNTIF(Sheet1!A:A,Sheet3!A1) in cell b1 and copy down as necessary.

What else are you looking to achieve?

Regards

Jeff

I want to make some calculations with the 10min totals on sheet 2, and then send a final value to sheet three.

I realize to get calls per day I could use another count if

Hi

If you could show manually what final output you would like to achieve it would be useful to know what to aim for.

Regards

Jeff