choose cells randamly

Question

Hi,

in  excel i have one error accur during selecting a cell. because the cell range is change it day by day.

 

EX:

 

filter the all column. after select company like a,b,c. i select c.then 

 

if i select range(k123) today.  but it change tommorrow after filter range shows range(k150)

 

so how i will select this type range while it change randamly.