Forum Discussion
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 gi...
You might create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.
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?