Dynamic Excel

[prince0717]

Hi Friends, is there anyone can give me some pointers. I want to build an excel data base where I can input data unsorted on a excel sheet and it will automatically segregate those data on different sheets?  just like I want to make a batch billing and it will have a individual ledger? 

[#2 · Accepted solution]

@prince0717 

Without any further description, it's hard to give more than a very general suggestion. How experienced and comfortable are you with Excel? There are some new functions--called Dynamic Array functions--that might be the key to your need. Here's a very useful and thorough YouTube video describing them and giving some illustrations.

FILTER and UNIQUE in particular could do the kind of separating you're describing. SORT could put individual items into a meaningful order on that billing sheet.

So give this video a look, and then come back with more questions--maybe a sample of your workbook as it exists--if you want further help.

https://www.youtube.com/watch?v=9I9DtFOVPIg

[#3]

@mathetes 

Thank you sir, this is what I've been looking for, as I am just started on digging deeper on excel this is a great great help on making my reports more functional and easy to use.