Copy formulas in a column to other column without incrementing?

[commodus]

Hello! It's been a while since I've posted in this forum and after searching through MrExcel and online I can't find a way to make this work.

I have reference data in Column D of a workbook that I need copied over to other columns, but not every one of them. For example I have dollar amounts in Column D Row 3-46. I then want to include a formula in Column I, O, U and others that reference those dollar amounts. I would normally just enter =D1, =D2 and drag downward however I have over three dozen columns to do this within. I've tried "paste special" and where I can paste the value, it won't paste the formula without incrementing it and making it void. More or less if I change my reference data in Column D to a different value later on I want each corresponding column (I,O,U) to change with it... I hope I've described that clearly enough and I know it's probably something easy but I just can't figure it out - would someone please help?!

Column D Column I Column O Column U
$10 =D2 (same as D2) (same as D2)
$20 =D3 (same as D3) (same as D3)
$30 =D4
$40 =D5

 

[bbott]

Hello,

You can change your formula to:
=$D2
Copy down. It will increment the row, but the column will remain D. Now you should be albe to paste special.