I posted this previously and recieved no responses. I assume that is because it was a poorly worded post. Im attempting it again.
I have a spreadsheet that contains columns for Date, Time, Temp C, and Temp F. There are a varying amount of temperature measurements each day (between 20 and 24). I have created additional columns for Hi, Average and Lo temperature measurements for each day. I have placed the formulas in the first row of the new columns. I want to copy the three formula cells and paste them in the same columns at the first measurement (row) for each day. My resulting worksheet would look like:
Date Time Temp C Temp F HI AVG LO
3/8/2004 0:00 4.4 40 41 41 40
3/8/2004 1:00 4.9 41
3/8/2004 2:00 5.1 41
3/8/2004 3:00 5.2 41
3/8/2004 4:00 5.2 41
3/8/2004 5:00 5.1 41
3/9/2004 0:00 3.6 38 41 41 38
3/8/2004 3:00 5.2 41
3/8/2004 4:00 5.2 41
3/8/2004 5:00 5.1 41
The first day is truncated to save space
The following macro is my attempt at this. Copying, pasting, and offsetting to the reference cell is working. The macro repeats itself until the date column is empty. What I don’t know how to do is note the value of the reference cell (date) then advance down the page (same column) checking each cell and stop when the contents are different than the reference noted.
Bookmarks