Relatively new to VBA (so labels help a lot), thanks!
I am trying to create a macro to track monthly changes in costs. A unique key requires columns D, F and J (community, plan and option). If there is a difference in column Q I would like to copy it to a third sheet. If a row has been added or deleted it should also be copied but highlighted green and red, respectively, in column Q. Lastly because column Q is a cost I would like it to display the difference (Sheet1 - Sheet2).
Thanks in advance
I am trying to create a macro to track monthly changes in costs. A unique key requires columns D, F and J (community, plan and option). If there is a difference in column Q I would like to copy it to a third sheet. If a row has been added or deleted it should also be copied but highlighted green and red, respectively, in column Q. Lastly because column Q is a cost I would like it to display the difference (Sheet1 - Sheet2).
Thanks in advance