Recall a SUMIF formula

[sammy1985]

Hi, Im new to VBA and trying to use this in my work to make tasks easier. I am competent in Excel but wanted to learn VBA to makes things much easier.

I work in finance and have to prepare the management accounts each month. The company's management accounts are set as a booklet, a tab for each department/project and each department has columns for each month of the year. Currently the reports are formula driven but i have to do this each month which is time consuming as i have to do this for 25 tabs!!! (not the best way to spend my time - the document was inherited).

I recorded a simple macro to see the code to better understand how it works. I have then copied this on other the tabs however, the SUMIF formula is the same throughout the booklet. Is there a way for me to write out the SUMIF formula once and recall this where i want it as I would need to do this for each month.

I hope this makes sense.

Thank you guy in advance!

Sammy

 

[steve the fish]

Hi. If you mean you want the formula in the same cell of each sheet referencing the same cells of each sheet then yes you can do that. You would need a list of sheets to miss out (or include).

 

[sammy1985]

Yes that is what i need it to do. is it simple to code up?

thanks