Frequency Macro

[Wayne Cramer]

I have a workbook where sheet 3 is updated each day. Sheet 2 contains the daily frequency by hour from the time column of sheet 3. I would like a macro to calculate the frequency and fill out the daily colun of the sheet each day. I can record the macro to do this but it wants to fill in the same column each time. If I moe to column D it will fill in the iinformation in column C once again. The times are always in column H of sheet # and the hourly time intervals are always in column B of sheet 2. Is there a way to perform the calculation and place it on whatever column I choose?

I also have a macro that copies the sums from sheet 3 and pastes the values in a row on sheet 1. This macro has no problem pasting the values on any row.

 

[unmarkedhelicopter]

Post a sample workbook of 2 days input and how that comes out in sheet 3 (colour them differently so we see the relationship) explain how any analysis is done and make sure you put some comments in your recorded macro. Comment lines are started with an apostrophe ' . Make the comments so we can uderstand where you are comming from in your analysis.