Hello all, I hope you can help me? I want to validate a list entry which was originally selected from a list based on a previous list selection. Chandoo's blog on the subject was great for creating a multi list solution...
Dear Chandoo,
For 2 years, I have had the need to condense entries from several datatables into 1 sheet so that I have a customer number with entries for each of the tables they appear in - That is to say, I want to combine the datatables into one table that shows every entry in one row for...
Dear Chandoo.
Please help me. I have an issue which began last year. Can Excel merge rows like a database does records? Either Formulas or VBA solution would be acceptable.
An example would be where customer activity is held on Excel. Each row contains a record of the customers' visit...
Hello everyone. I wonder if you can help me debug a formula? I need to include several criteria which are parts contained within longer entries. Firstly, let me tell you the criteria; 1-5 are selected from dropdown lists by the user:
1. Month = 11
2. Year = 2011
3. Status = Finished
4...