Vikijadhav18
New Member
- Joined
- Jul 9, 2022
- Messages
- 12
- Office Version
- 2013
- Platform
- Windows
Hi Expert's,
Need you help in order to generate the report based on the data.
Data is available in the 1st sheet " Data" wherein employees details & their salaries month values has been mentioned.
In the 2nd sheet "Output Required" I need vertical report of each employee. From Sr. No 1 to 5 details will be the same mentioned in their respective column in the Data sheet.
However, in the Sr. No 6 (Value) will be unique. Giving you below the examples for your better understanding
Example 1. If throughout the year i.e. April 21 to March 22 there is no changes in the value, then there will April month in the Month heading & the respective months value should be there in the column
Example 2. If throughout the year i.e. April 21 to March 22 there is/ are any changes occurred, then that month should be appears in the Month column & that months respective values should be there in the columns.
Please help to generate the report.
Need you help in order to generate the report based on the data.
Data is available in the 1st sheet " Data" wherein employees details & their salaries month values has been mentioned.
In the 2nd sheet "Output Required" I need vertical report of each employee. From Sr. No 1 to 5 details will be the same mentioned in their respective column in the Data sheet.
However, in the Sr. No 6 (Value) will be unique. Giving you below the examples for your better understanding
Example 1. If throughout the year i.e. April 21 to March 22 there is no changes in the value, then there will April month in the Month heading & the respective months value should be there in the column
Example 2. If throughout the year i.e. April 21 to March 22 there is/ are any changes occurred, then that month should be appears in the Month column & that months respective values should be there in the columns.
Please help to generate the report.