Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

need a macro

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


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question