Clwd9Rider
New Member
- Joined
- Mar 29, 2019
- Messages
- 5
Hi all, I need your help in the below issue
need: sum a production table based on months deposits.
what I have: 1: sheet for each client with a table of deposits monthly based
2: all amounts in same rows of all sheets, but months are in different columns
what I want: to sum months deposits in my master sheet.
for example: in sheet1 the month Sep-18 is in D5 and amounts in D6 D7 D8, in sheet2 the month Sep-18 is in E5 and amounts in E6 E7 E8 ...etc
I have uploaded a test sample of my excel file, the real one is much much bigger with 10s of sheets, but this would help to understand my problem.
so as you can see, I would like to add the deposits in the clients' sheets in the Table of monthly production in the IB Sheet.
So basicly I need in the
Thank you in advance for help
need: sum a production table based on months deposits.
what I have: 1: sheet for each client with a table of deposits monthly based
2: all amounts in same rows of all sheets, but months are in different columns
what I want: to sum months deposits in my master sheet.
for example: in sheet1 the month Sep-18 is in D5 and amounts in D6 D7 D8, in sheet2 the month Sep-18 is in E5 and amounts in E6 E7 E8 ...etc
I have uploaded a test sample of my excel file, the real one is much much bigger with 10s of sheets, but this would help to understand my problem.
so as you can see, I would like to add the deposits in the clients' sheets in the Table of monthly production in the IB Sheet.
So basicly I need in the
Thank you in advance for help