Forum Discussion
Solved
Changing a formula across disparate cells
So, I have a number of diagrams to create. These are traffic flow diagrams, which show the traffic flows on say 40 junctions in a network, with different direction arrows etc. A big spreadsheet then....
- Find and Replace might be an option to update the formulas quickly. If you're able to share a sample workbook, myself or someone else might be able to recommend a specific solution.
Find and Replace might be an option to update the formulas quickly. If you're able to share a sample workbook, myself or someone else might be able to recommend a specific solution.
Patrick2788 thanks for the quick response. This is a very small snapshot of the type of spreadsheet I have. If you imagine this multiplied by 8 we are there with the amount of cells I need to change. Each cell where there is a number has a similar formula, referencing another worksheet for example. I need to change the formula slightly, but for each cell in my diagram. I want to it a little more quickly than update one cell and the copy-paste to another. I suspect it might have to be some form of code, which I can't do!
- Code may very well do it but the amount of time needed to script the code may be about the same if you were to update the cells manually.