Forum Discussion
Mcphet
Feb 15, 2020Copper Contributor
Populating cells across a row depending on a value in a column
I have created a voltage drop calculator for work. It’s pretty basic sheet at this point. What I want to be able to do is, depending on the number of nodes on each line, populate the row with the correct number of cells containing the correct formulas required for the number of nodes. Can i create the rows containing the formulas elsewhere and pull them into the sheet depending on what number of nodes are required?
1 Reply
- Riny_van_EekelenPlatinum Contributor
Mcphet Yes, you can. Have attached an example with some options demonstrating how each works.