Want to create a sales ledger
I have to maintain multiple clients ledgers now my boss wants me to summaries them in one ledger but the issue is he wants complete entries like date / invoice no / description / debited amount each and every ledgers entries fetched in single sales ledger datewise now i need some experts to help me out
thanks in advance
Madness
KASHIFKHAN86
Why not all data in one worksheet. It makes it a lot easier to analyse.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Because we can't merge each and every client in one page due to giving them ledger copy when needed
Looking for the solution so when ever i update my clients ledgers sales ledger automatically updated
If you had a more recent version of Excel, you could use PowerQuery, but unfortunately your version is too old.
I disagree with your comment above: you are putting the cart before the horse. It would be MUCH easier to maintain the data in one worksheet and then pull out a filtered report when clients need to see their personal ledger.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Appreciated ma'am to see you herewell give me a better solution so i can get rid of this confussion
No - sorry. I have suggested what I would do. I can't share a PowerQuery solution, as you don't have it. My advice is to change the way you are working.
means there is no solution for me right now
Yes, there could be a solution.
Maybe VBA to get all data in 1 worksheet.
But the advice is not to work that way.
It is a statement for your own benefit.
Not from me, no. Sorry. Be patient, please.Originally Posted by KASHIFKHAN86
Against my better judgement.
App uses tables - table name and sheet tab name must be the same.
you may have to take the balance column out of the table and make it a range if you have formulas in place.
Just an idea as its been raining and i was bored.
torachan.
To avoid corrupting the table with formula I have put the calcs in the code.
So NO formula in any of the tables.
If you follow the same format/structure, add a table ensure table name and sheet tab are identical.
The selection combobox will expand with the new addition.
Keep 'Front_End' and 'Sales_ledger' as the first two sheets.
torachan.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks