Forum Discussion
Fill in cells based on data from other sheet
I am struggling with a template that I use ( https://templates.office.com/en-us/employee-absence-schedule-tm03987167). I added some sheets that are the basis for the information displayed in the mont...
Excel
Start
Search and select (top right, with binoculars icon)
Replace
Search for:
Replace by:
Regulate options as desired and execute.
Thus all formulas or links from example copied January are converted to February.
Example: = OR (AND (F $ 8> = (January! $ I $ 9;)) replace January with February and the formula in the newly copied sheet then becomes = OR (AND (F $ 8> = (February! $ I $ 9;) ) ... so you can quickly change all the formulas in a copied sheet.
If my answer has led to a solution, I would appreciate feedback, thumbs up.
If this not the solution you search please ignore or inform.
Nikolino
I know I don't know anything (Socrates)
Start
Search and select (top right, with binoculars icon)
Replace
Search for:
Replace by:
Regulate options as desired and execute.
Thus all formulas or links from example copied January are converted to February.
Example: = OR (AND (F $ 8> = (January! $ I $ 9;)) replace January with February and the formula in the newly copied sheet then becomes = OR (AND (F $ 8> = (February! $ I $ 9;) ) ... so you can quickly change all the formulas in a copied sheet.
If my answer has led to a solution, I would appreciate feedback, thumbs up.
If this not the solution you search please ignore or inform.
Nikolino
I know I don't know anything (Socrates)