Forum Discussion
Auto populating a row in a sheet based on a row in another sheet!
HansVogelaar Thanks for helping - here is the link! - https://docs.google.com/spreadsheets/d/1wg4-mueUoeTqrtyQA-dhh15pQXsOboRu/edit?usp=sharing&ouid=108196231026211266064&rtpof=true&sd=true
See the attached version. Doing this fully automatically would be complicated.
I added a button to the template sheet that will update the other sheet.
- Thank you very much - deeply appreciated. I'm trying to understand how you did the such that I can make a modification in that the "SONALIKA" worksheet would consist of 2 categories of products and so would "SONALIKA MASTER". If one category is updated in "SONALIKA MASTER" (say CI), then only products corresponding to CI in "SONALIKA" should get updated. Not sure if this is an easy modification or if this was what you were referring to as complicated but I thought I'll give it a shot.
How can we determine which category a product belongs to?
HansVogelaar Hey Hans, sorry for the delayed response. I've modified the sheet to reflect that, here's the new link - https://docs.google.com/spreadsheets/d/1J9Wx_S01FQBc64Ju9OoPf_H-xPwBjLdY/edit?usp=sharing&ouid=108196231026211266064&rtpof=true&sd=true - in "Sonalika Master", I can have two categories - CI and SG - and master table for each. In the "Sonalika" worksheet, I added column for product category and each category can belong to either CI or SG. Based on which one is updated in the master, the products belonging to that category should get updated in the "Sonalika" worksheet.