Spreadsheet attached.
This is just an example of what I'm working with. I have a lot more rows. What I need is the following. In column D, I would like to do a search replace so that all of the AL references will take the value in O7 and all the AM references will take the value in 08. Ideally I would like to do a find and replace to insert the formula (I have tons of rows).
I want to do the same thing for column E and F, linking them to P7 and P8 and Q7 and Q8.
One important note: I just want ot make the columns reference those cells, the rows need to stay hard coded.
Bookmarks