Auto fill formula in only unhidden cells.

[jordan11221992]

For my order guide I'm creating I have it set so it's shelf to sheet o make counting easier making counting inventory like readingg a book left to right. That being said, I have 8 different vendors that I can product of. I also have an "order" column. I've placed it all into a table so I can easily filter by vendor. However, I need to make a sheet for each vendor with rows showing what I have on hand, what I want through over the week, and what I want to order. All without having to manually type =(d24/f24)+(c24)... (Individual units/units per case)+(full cases) giving me a decimal (2/24)+(2)=2.08 cases on hand. I want to filter to one vendor and type this into the first row then auto fill so I don't have to type it into hundreds of cells manually but when I try to it auto fills into the unfiltered cells making it all inaccurate. Can someone help me?