Quote Originally Posted by FDibbins View Post
Hi and welcome to the forum

1st, instead of deleting a row that you no longer need, delete teh contents instead
2nd when you make your links, try is this way...
=IF(Sheet2!A3="","",Sheet2!A3)

This way, you can copy that wayyyy down, and if there is nothing in sheet2 then sheet1 will not show anything
If you need to "remove" the rows you deleted the into in (1 above), you can eithetr hide that row, or sort your data

If this doesnt do waht you want, let me know please (and why it doesnt work?)
Hi FDibbins,
so with the links I have found that it could only work if I make a specific master list to reference as using any other table causes issues with filters and sorting being applied as it messes up the order of the others. Also by just deleting the contents in the product name would not clear the many other columns for each table or require some if statement as well. Though I wonder if a conditional filter or something could solve that by IF the product name in the row is blank then delete the field. Though hat would have to be configured for every other cell. Also that does not fix the issue of needing to create a row or expanding the table when a new name is added to another column as they would have to reapply the filters. Great thinking though, let me know what you think and when you get a chance to look over the basic sample I have posted

Thanks