Oct 31 2021 01:29 AM
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
Oct 31 2021 02:54 AM
Oct 31 2021 04:42 PM
@Yea_So 2019 version
thank you
Oct 31 2021 04:55 PM
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:
Find the first value from a column - Microsoft Community
as you can see in that post, the sample data set largely differs from the sample data set that was shared.
Oct 31 2021 07:08 PM
@Yea_So Product list is my main table, the one i will add on and remove rows, the Stock Value is the one that i would like to follow accordingly on what happen in the main table.
thank you for time
Oct 31 2021 07:47 PM
Oct 31 2021 09:17 PM
Oct 31 2021 09:22 PM
that would be optimal so if I can find other things for you that would be one less problem for you to deal with
Oct 31 2021 10:16 PM
@Yea_So Here is the file again
thank you
Nov 01 2021 02:41 AM - edited Nov 01 2021 02:53 AM
After you add the new entries in Product List sheet, press ctrl+alt+F5 to refresh the Stock Values sheet.
Here you go:
Solution Reference/Credits:
Self Referencing Tables in Power Query - Excelerator BI