Hi all,

I have about 25 workbooks that I would like some help. In every workbook, i have a worksheet named "FY21-Budget Variance".

In all of the worksheets, in Column F, from rows F6 thru F250, I have the word "Budget". Depending on how many accounts i have i could have the word "Budget" repeated at least 25 times or more--sometime less.


As an example, in row F20, I have the word "Budget". Then in Column H, I have the following formula in cell H20, "=SUM(H15:H19)".

With a macro I would like to copy the range from H20 all the way thru Column AD20 for every row where the word Budget is shown in Column F.

Any help is much appreciated.

I hope this is clear. If not, please let me know.

Regards,
rsrasc