stanleydgromjr

stanleydgromjr, Please keep all posts in thread please

Hello,

I've been working on updating the spreadsheet/macro that you helped me with a few months ago.

http://www.excelforum.com/excel-prog...p-by-date.html

We added an extra column to the "output" tab right at the beginning as the new column 'A', along with more information of the same format. I also added a piece of code that adds the date that was searched to the "schedule" tab. Other than that no changes I am aware of, but for some reason it only displays one line in the schedule tab and then stops. I have tried playing with the code and nothing seem to help or hurt. Any ideas?

I greatly appreciate all the help you have been. I have posted the updated code on the forum page that I pasted to this message.

=AVERAGE(C4:L4)
=SUM(C7:L7)
=SUM(C10:L10)
=AVERAGE(C13:L13)
=AVERAGE(C16:L16)

I think these are the formulas you are looking for? I'm sorry that I'm not very knowledgeable about Excel. I still need a better explanation of what you mean show changes between sheet 1 and 2 please. Thank you.

How do you create a macro? I tried but it does not seem to work. Here is what I am trying to do.

=ROW(A1)&"F"