Hi,

I have a project management worksheet with 25 tabs names Page-1 to Page-25. Each tab is perfectly identical in terms of formating. Each tab is a project. Not all tab are populated, for instance right now we only have 10 active projects so we have 10 active sheets out of 25 already formatted. I also have a summary tab with various useful information and reporting information
The worksheet is used for our monthly project financials tracking and reporting activities.

I would like to have a macro (I am not good enough with macros yet) that will allow me to freeze formulas into values at the end of my month end process, the values would be the project financial information (consultant billing) for the given month.

The way I see this happening (but I am open to suggestion if there is a better way to do this) is that in my summary page there would be a cell where I would input the current month, and the process would check what month is in that cell and transform into values the content of a given range of cells (always the same range for rows, it's just the colums that change from one month to another...so for a specific example, for the month of april it would be cells G168 to G227, and the month of may would be cells H168 to H227) across a given range of tabs (at this point in time for instance it would be page-1 to page 10).

Finally, I would like that macro to be associated with a button so at the end of my month end process I would just click and have that process run.

Hope I am clear with my explanations.

Any help is appreciated.

Loulite