Forum Discussion
Formula Help
Hello! First time posting here. While I have used excel and love using it, I cannot figure out this formula/what the best route would be. At this time, I want if one cell shows this text, fill i...
WHAT I UNDERSTOOD
You want to set a formula after which if you change text in a particular cell, it should reflect in a big range.
for this just apply the formula
suppose the text you want to be copied is at C3 then it should be =$c$3 in all the cells where you want to copy the text of c3. Now whatever you put in c3, it'll be copied to all the cells.
it'll make the location absolute and you can copy it to as many cells as you want.
you can refer here for more valuable information gyankosh.net/msexcel
- Thank you for this explanation! However, I do not believe this will fit in the sheet I am working on. I apologize if I was unclear or am not understanding your explanation.
Based on the photo provided, The information from cell BC, and below, can change based on what is inputted in a different sheet. For the current info in BC3, I would like G3 through AN3 to be filled with the info seen in cell C3. However, if the info in BC3 were to change to “Early,” I would like cells D3 through AK3 to be filled with the info seen in cell C3. Not quite sure how to do this and when I entered an IF formula that I thought would work, I received an error. Any further assistance or advice would be appreciated!Belle324 Perhaps like in the attached file? I've used a small table where you set the shift start and end times. Cells in AZ and BA are updated based on the selected shift in AY.
