Forum Discussion

vishrutGoel's avatar
vishrutGoel
Copper Contributor
May 27, 2022

Auto populating a row in a sheet based on a row in another sheet!

Hi, I'm trying to apply some formulas/ functions to an Excel worksheet where there is pricing details for each product as can be seen in the "SONALIKA" worksheet. The variable here is the increase given to the product and the increase is mostly same for each product (products are categorized into two categories and price increase for products in one category are the same). I'm trying to create a master worksheet such that I can add the price increase for a category in this worksheet and that auto populates a row for all products of that category in the other worksheet such that now we would have a new row added at the bottom for each product of that category with the date, increase given etc. I'm just trying to think of the most optimal way to do this.

 

One way and probably the easiest is to not have a master but just added a new row for one product and then auto populate a new row for other products in that category with the same values but I don't think this is most optimal. I feel having a master sheet is more intuitive for the user but not sure what formulas/ functions to use to achieve the above stated goal using this method. 

 

Any help would be much appreciated, thank you!

 

(Tried to add the file here but could not see an option to do so!)

9 Replies

Resources