Hello everyone and happy Friday,
I would like to be able to run a report from a data sales which could be very long as it records all sales data from different fruits every month and every financial year.
The thing is not every fruit has a report for the month so sometimes, there is a gap or also the report comes in later so the chronological order is not always respected on the Sales data (as highlighted in the workbook).
Pivot can give me part of what I want but not what I really want, which is to see whether the status report of every fruit on a monthly basis (as per the Report worksheet).
I put on the Report sheet some more explanation but really what I want to achieve is that a monthly overview of sales for a selected fruit for a selected FY(financial year) and that overview always follow the start of the FY which is May and ends in April. So if there is no report then it will be a gap on the corresponding month, and if there is a value then that will be copied on the corresponding month as well. . If there is only one report, let's say only Sep-18 for one type of fruit for the whole year, then that would be displayed on the result on the 9th row of the result and not at the top of the row as it searches for the empty one.
What I thought:
- Either do vba custom sort on the range E8:G19 but I think it will be tricky
- Or add a integer j for the column but then as the FY changes, I wasn't sure how it will work.
I'm sure there is a better way for achieving this from the existing code.
I really appreciate your help and thank you very much.Please Login or Register to view this content.
Rako
Bookmarks