Can you drag the company name into filter and select the ones you want to display only?
Just thinking out loud.. Not sure if this is feasible, but you can create a new field in your database which will have a timestamp associated with it. So all the newly added rows will be automatically time-stamped.
You can then filter out those records based on the desired timestamp.
Thanks for responding, but I cannot do that as it affects my calculation.
That would have made sense, but if new rows are created for company, I need them to be hidden automatically, so that I don't have to manually make changes to my workbook.
If you need to calculate with filtered data, you can use Fixed LOD in your calculation and this will calculate value before it is filtered.
If you can provide a sample workbook I can show step by step how to achieve it.