Taking this one question at a time, the proposed solution to the "Monthly and Factory Wise Summary" is as follows:
1) Take advantage of the layout of the 'Master Sheet' by adding a helper column with the month number. The first cell is manually filled in and the rest of the column is populated by the formula:
2) A second helper column coverts the month numbers to dates (formatted mmmm'yy) using the DATE function as follows: =DATE(2017,Y8,1)
3) The formula that populates the 'Month and Factory Wise Summary' sheet in the range D10:H28 is:
Note: Column B is now populated with dates formatted mmmm'yy
Note: This is being returned as an .xlsx file as your profile shows you have the 2016 version.
I'll work on portions 2 and 3 later unless another contributor has solved those beforehand.
Let us know if you have any questions.
Bookmarks