Is there anyway to copy the formulas in the first blank row of a worksheet to a row number of my choice
I have a sheet which will receive information daily but based on criteria some of these rows will be deleted by macro if certain criteria are met. As this macro is deleting rows I need to ensure that the formulas are copied down far enough to ensure they do the calculations for the delete criteria.
Thanks for any help
Bookmarks