Forum Discussion
how to automatically add a new row in a table if i add a new row in another one
thank you to whoever would like to help me
i have a main table with some products and other info, a secondary table which get some info from the main one. now my problem is if i insert a new row in the main table how can i have a new row automatically added in the secondary table? i m using index and match to populate the secondary table but i need to get this new row added or removed when i add or remove products in the main one is that possible with some formula? i not very confident in use coding, script or visual basic etc.
thank you
Paolo
9 Replies
if your data set does not have any confidential information it would be better if you shared your data set so we can come up with a solution that is based on real data set.
below is a poster who shared a misrepresentation of their data set that received a solution based on a mis-representation and is complaining that the suggested solution isn't working:
https://answers.microsoft.com/en-us/msoffice/forum/all/find-the-first-value-from-a-column/9b058be4-e8ff-4c00-907c-75eb8a71acc7?messageId=af28d6b3-989a-46b3-aed0-69a433743a7f
as you can see in that post, the sample data set largely differs from the sample data set that was shared.
