If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy dynamic data into another static cell

Thread starter EvansRJ
Start date Apr 18, 2019
Tags

cell copy data dynamic static

EvansRJ

New Member

Apr 18, 2019

Hi Folks,

If you look at the screenshot you will see a column "B" for entering my daily sales, column "C" for remaining units for the quarter and I want to add a third column "D" for Daily Trend to Quarter target. My question is that I simply want to copy the data from cell "BC9" into the new "D19" for April 1 but when I continue entering my daily sales, BC9 will change each day but I don't want the data in column D to change along with it.

Please help.

http://tinypic.com/r/esrb0m/9

Thanks!