basic macro help

[deck-b]

hi all

i created a macro to run off of some filtered data, and copied a formula down, but when the data gets updated the now filtered rows do not match where i had copied the formula, so the formula is on rows that i do not want and is returning n/a's. is it possible to write a code that will recognise that the filtered rows are not the same as the original ones when i wrote the macro? hope this make sense