Hi there
Can someone please help me with some VBA code.
I have a Business Objects report exporting cumulative daily sales by month to Excel (Export sheet). Unfortunately when a new month starts the cumulative daily sales is reset to zero.
I want to be able track the end total for each month (In the YTD sheet). I was thinking a macro could be written to determine what the current month is (as identified in the Export sheet) and to paste the sales figure under the relevant month (in the YTD sheet. Therefore, for example, the October monthly sales is pasted safely under October when the cumulative total resets in November.
Hope this makes sense and that someone can help me out!
Thanks,
Jason
Can someone please help me with some VBA code.
I have a Business Objects report exporting cumulative daily sales by month to Excel (Export sheet). Unfortunately when a new month starts the cumulative daily sales is reset to zero.
I want to be able track the end total for each month (In the YTD sheet). I was thinking a macro could be written to determine what the current month is (as identified in the Export sheet) and to paste the sales figure under the relevant month (in the YTD sheet. Therefore, for example, the October monthly sales is pasted safely under October when the cumulative total resets in November.
Hope this makes sense and that someone can help me out!
Thanks,
Jason
