I have a personal project I'm doing with Excel that some VBA code would help with, but I'm not very skilled at writing VBA code. Hoping someone might be able to whip something together quickly for me.

My spreadsheets uses a FILTER function to pull data from external workbooks, after which the data is converted to text. Cells outside the pull range have formulas that act on each row of data ... these formulas are stored in the first row. Once the data is imported via the FILTER function the calculation cells have to be brought down to each row of resulting data.

Because the source data can vary in how many of rows it has, the code has to be dynamic -- copy formula to row x when row x is the last row of data. Obviously, knowing which row is the last row requires looking in a different column.

FWIW, the spreadsheet has 16 worksheets all which pull data from different sources, so the code has to handle all of them. I'm not sure if that means the code has to be specifically built for each worksheet, or if a generic code can be written that can be applied to each worksheet as necessary.

Thanks for any help.