I am organizing a conference. No of guests would be large say 100. I need to arrange for accommodation in hotel. They will be coming and leaving at different times depending on their flight timings. I am arranging the accommodation for all at the same hotel and the check-in/check-out time is say...
Here is my problem. I have 3 different parameters customer, selling location and product in 3 different columns. My price will be a function of these 3 parameters. To upload these prices in system i have to get a linear excel table with all possible combinations possible. I can use macros to get...