Hi, Thanks to Jarko28 I was able to create a really nice quoting tool in Excel. Of course now I’ve been playing with it and tweaking it so I now have a new question.
I was looking to randomly generate a quote number. Reading older posts I found two that interest me and I was wondering if there is a way to combine them. I created two data validation lists, one I made the data =TODAY() and then set it to be general format so it shows the date as 41400. The other note I saw was regarding a general random number generator. That was set up in the answer to the question I read as =INT(RAND()*(322-132)+132) Is there a way to combine them both so that if I click that dropdown it would generate a number starting with the current days date in the general format plus 3 digits? Such as 41400257? I have the two formulas but I can’t seem to get them to work together. I am open to any ideas or changes to this if there is a better way. I like the current date in the general format and then just some type of 3 digit identifier. It can be sequential if easier than random. That doesn’t matter as long as they don’t repeat in the same day. At the most I may only generate 10 to 12 quotes in a day.
Any help or ideas would be greatly appreciated.
Dave
Bookmarks