Vba to track changes to a range on the same spread sheet

[jondavis1987]

In a workbook I have about 40 worksheets. each worksheet has a range that i want to track changes to. To start with I'm trying to do one sheet at a time. In worksheet Superpave Template there's a range C5:H5 that has percentages. Down at C40:H40 i have the same percentages. B39 has a formula that is =TODAY()

I would like to make it where if i change anything in C5:H5 it will automatically put the Date from B39 into the first empty row at the end of column B and then put the percentages from C5:H5 in their respective columns in the same row where B39 just got copied to. I don't know much about making VBA. What i would like would look something like what i have below but that code isn't working. The *** IF Range.("C5") = Sheets("Superpave Template").Range("C" & lastRow). Then *** is in red on ever single one of the ifs.

Also realizing that i made the code look as if it equals then it should do that. It shouldn't. If it doesn't equal that then it should run that code

Please Login or Register  to view this content.

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.