Selecting specific range of cells based on current month

Hello,

I am currently trying to automate a process at work.

In the workbook attached, under the column labelled YTD (Cell O4), I have to update the formula to include the current month (July), this process is repeated each month.

I am wondering if there is a way to automate the process through a macro so that Excel knows that it needs to pull the sum of Cells B:H if it's month of July. Cells B:I if its the month of August etc. etc.

Please let me know if you need additional clarification. Thanks in advance for your help.

Sohshak

Wow! That formula works wonders!!!

Thank you so much!!


Follow up Question:

I use these numbers to generate a waterfall graph. The process goes that I will copy these numbers into a table (Cell Q6), divide by a thousand, and link them to an excel graph.

This process is repeated each month for Current Month (CM) Year to Date(YTD) and Total Year Outlook (TYO) numbers.

Is there a way for excel to "detect" that this month is the month of July and "pick up" the variance numbers from July in column U.

I hope the attached spreadsheet further clarifies my request.

Please let me know if you need additional clarification.

Sohshak

I want to pick up rows 33 to 42 under the Variance table.

I am sorry, did that answer your question?

Do you need additional clarification?