Macro to paste a comparison formula into a selected range

Can do Arlette, thank you! I've built and attached a really quick example. I might recieve output from our accounting software which contains year-over-year comparison data for a company. In the sample spreadsheet, column D would be blank initially. What I would like the macro to be able to do is allow me to select a range by mouse/highlight (in the sample spreadsheet D2:D6), and then paste the function into it. I guess what I would need is for the code to be flexible enough to allow for different lengths and values of column selects and for the formula pasted to reference the cell it is pasted into. I didn't know if it was possible, but since my output consistently will follow the row order of Current Year then Prior Year, I wanted to have the formula itself hard-coded into the macro itself to save the time of writing it in each column and copying down so frequently. Hope this makes it a little bit more clear.