Need Formula for Many person's account handle
- Thread starter sa.1985
- Start date
SirJB7
Excel Rōnin
Hi, sa.1985!
Please clarify this points:
a) sheet 'Clients Details' has all the clients you've had since you started, that's to say you never delete entries
b) for each of these clients you have one sheet 'Client N', that it's created when you add an entry to 'Clients Details', which reflects all the operations or fund movements for that client N since it's very first additon
c) sheet MASTER has all the operations of all the clients, which are distributed and reflected in each individual client sheet
Questions:
1) why would you delete movements in sheet MASTER? according to c), you shouldn't
2) what's the main concept for "Opening"? it's only once when you start working with that client? if so, I understand that it's in D3 once but, why in F column for all the movements?
3) why do you say 'editing in data in sheet client1,2,3'? these sheets should display data from 'Client Table' and MASTER sheets, and should not allow editing at all
Comments:
If a), b) and c) are right, and answer to 1) is no, and answer to 2) is only once, and answer to 3) is not editing, then I think I got the idea. Let me find a couple of free hours to rebuild your workbook so as to handle N clients and maintaining individual client sheets, and sending it back to you.
If I'm wrong in a), b) or c), or the answers to 1), 2) and 3) differ from what I wrote, please explain in detail the workflow of the real transactions and how to you propose to enter what data in what sheets, and what is the expected output.
Regards!
Please clarify this points:
a) sheet 'Clients Details' has all the clients you've had since you started, that's to say you never delete entries
b) for each of these clients you have one sheet 'Client N', that it's created when you add an entry to 'Clients Details', which reflects all the operations or fund movements for that client N since it's very first additon
c) sheet MASTER has all the operations of all the clients, which are distributed and reflected in each individual client sheet
Questions:
1) why would you delete movements in sheet MASTER? according to c), you shouldn't
2) what's the main concept for "Opening"? it's only once when you start working with that client? if so, I understand that it's in D3 once but, why in F column for all the movements?
3) why do you say 'editing in data in sheet client1,2,3'? these sheets should display data from 'Client Table' and MASTER sheets, and should not allow editing at all
Comments:
If a), b) and c) are right, and answer to 1) is no, and answer to 2) is only once, and answer to 3) is not editing, then I think I got the idea. Let me find a couple of free hours to rebuild your workbook so as to handle N clients and maintaining individual client sheets, and sending it back to you.
If I'm wrong in a), b) or c), or the answers to 1), 2) and 3) differ from what I wrote, please explain in detail the workflow of the real transactions and how to you propose to enter what data in what sheets, and what is the expected output.
Regards!