• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hardcode Values based on certain date in a column

SeeztheDay

New Member
Hi all - I am trying to figure out a way to hardcode certain cells in a specific column by matching the date in that column to a certain date. In the attached file, I want to be able to hardcode all of the cells in a certain column where the text is colored blue down to row 73. The column would be selected by the the date in cell A1 matching the date in row 4. Feel like this might be kind of simple, but I am not very good with macros, so any and all help is appreciated.

Thanks
 

Attachments

  • AM Model - CF Actuals.xlsx
    319.9 KB · Views: 1
Back
Top