Helo Gurus
please let me know how to write a macro for the below
there is a report where i have MTD,QTD,YTD,FY tabs for all the 7 products with Actual,plan and Budget versions
all the tabs must expand based onthe selection of the month in the MTD tab which I have accomplished
MTD is fine, when in QTD i want to get the month data for all the three versions ( i know i can get this by hidden sheets with the expansion on all the three versions but this is going to be 7 * 3 which is 21 with all the 12 months for each i.e this is going to be a performance problem and an issue with excel being slow, since already there are 4 Tabs)
the issue with QTD is , since our year starts in april and the quarter is aril may and june , and if the user selects may in MTD the report must drive may to QTD and YTD respectively
when may in QTD the accumulation must happen for april and may
if YTD also goes the same
thanks
please let me know how to write a macro for the below
there is a report where i have MTD,QTD,YTD,FY tabs for all the 7 products with Actual,plan and Budget versions
all the tabs must expand based onthe selection of the month in the MTD tab which I have accomplished
MTD is fine, when in QTD i want to get the month data for all the three versions ( i know i can get this by hidden sheets with the expansion on all the three versions but this is going to be 7 * 3 which is 21 with all the 12 months for each i.e this is going to be a performance problem and an issue with excel being slow, since already there are 4 Tabs)
the issue with QTD is , since our year starts in april and the quarter is aril may and june , and if the user selects may in MTD the report must drive may to QTD and YTD respectively
when may in QTD the accumulation must happen for april and may
if YTD also goes the same
thanks