I use Excel 2013
Any thoughts / help on either you knowing of an Excel program that does this, or if not, some help on creating one
What I enjoy is remembering the order of a deck of cards to practice memory
F9 could reorder 52 rows into 2 of Hearts, 3, and so on down the various cards
Adding an image of each card would be an added bonus
I can already Randomize numbers, but my issue, of course, is having the name of the cards that are randomized
Many thanks for your consideration
Hi,
One way would be to create a lookup table with 1-52 in the first column and the text description of the each card in the second column, then just use the randomised card numbers as the 1st element in a VLOOKUP().
Adding an image shouldn't be too difficult. If you'd like to add 52 images of pictures, suitably named, preferably with a numerical prefix then no doubt we can come up with a macro that would find the appropriate image and copy/paste it to the appropriate places.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks