DAWINDERBABBAR
New Member
- Joined
- Dec 5, 2009
- Messages
- 7
[FONT=Open Sans, Helvetica Neue, Helvetica, Arial, sans-serif]I have tried every possible way that I know and I am not half as expert as on this forum.Wondering if any of the experts can please help me[/FONT]
[FONT=Open Sans, Helvetica Neue, Helvetica, Arial, sans-serif]The workbook has 3 tabs, one for 2017, one 2018 and the master file. The tabs are the charges which are mostly weekly so lets say for e.g a customer with customer code 10001 could have 5 different charges for week 1 and have 5 same or different in week 2 and so on. Each charge has a charge code. The same applies to 2018 data.What I need to do is summarize it in away where the code will read the master date which has customer ID and then search under 2017 and bring all charges for January and will summarize the charge codes together for the month. Then the code searches the same in 2018 and for the same customer and the same charge code brings the billiable units for 2017, the charge rate for 2017, total billed amount for 2017 and the same date for 2018 next to it.[/FONT]
[FONT=Open Sans, Helvetica Neue, Helvetica, Arial, sans-serif]The workbook has 3 tabs, one for 2017, one 2018 and the master file. The tabs are the charges which are mostly weekly so lets say for e.g a customer with customer code 10001 could have 5 different charges for week 1 and have 5 same or different in week 2 and so on. Each charge has a charge code. The same applies to 2018 data.What I need to do is summarize it in away where the code will read the master date which has customer ID and then search under 2017 and bring all charges for January and will summarize the charge codes together for the month. Then the code searches the same in 2018 and for the same customer and the same charge code brings the billiable units for 2017, the charge rate for 2017, total billed amount for 2017 and the same date for 2018 next to it.[/FONT]
