Forum Discussion

Mcphet's avatar
Mcphet
Copper Contributor
Feb 15, 2020

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?