https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet Style Advice for Fashion Lovers en-US Sat, 25 Apr 2026 05:17:36 +0000 http://bbpress.org/?v=1.0.2 q https://youlookfab.com/welookfab/search.php https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490305 Sun, 18 Dec 2011 01:24:55 +0000 Makrame 490305@https://youlookfab.com/welookfab/ <p>Since I have no idea how to write macros, for now I am just sorting by dates worn.</p> <p>Here is what the result looks like.</p> <p>I will probably end up switching to a separate notebook for outfit combinations eventually but so far this works for me. </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490301 Sun, 18 Dec 2011 01:11:32 +0000 Lisa 490301@https://youlookfab.com/welookfab/ <p>I'm keeping an eye on this thread, neat idea! I currently use separate workbook in excel for my outfit combination's. I like the handy list on days I am stumped on what to wear in the morning. And it let's me keep track out outfit combination's I favor. </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490269 Sat, 17 Dec 2011 23:56:37 +0000 Kate 490269@https://youlookfab.com/welookfab/ <p>I'm so happy that the spreadsheet is working for you! </p> <p>I have no idea how to do this (or how to write a macro), but I'll be following the thread to see what I can learn. I love the idea of color coding how good different outfit were, I never would have thought of that! </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490170 Sat, 17 Dec 2011 19:52:48 +0000 Amy 490170@https://youlookfab.com/welookfab/ <p>That sounds like a great system! </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490168 Sat, 17 Dec 2011 19:50:30 +0000 Makrame 490168@https://youlookfab.com/welookfab/ <p>Thanks, Angela and Amy! </p> <p>Good point about 365 outfits - this is probably too much to be meaningful. For now, I have only been keeping track of what I wear when for about a month so I have not repeated too many combinations. I would like to keep track of which outfits worked really well and perhaps even print out a list or sort my clothes so that the entire outfit is in one place in the closet, to make it easier to get dressed in the morning. I do not have a problem with wearing the same combination multiple times (say, every two weeks) so that would make my life easier.</p> <p>I have sorted my spreadsheet by dates and discovered that my new version of Excel has color-coding built in for "good" (green), "neutral" (yellow) and "bad" (red) so now my outfits are color-coded. I added comments for the combos that are coded red, such as "needs turtleneck instead of t-shirt", "sweater looks baggy" etc. </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490125 Sat, 17 Dec 2011 18:32:43 +0000 Amy 490125@https://youlookfab.com/welookfab/ <p>Hmm...as Angela said you could create a macro or sort then copy and paste into a new worksheet. You could also use Excel's advanced filter.</p> <p>Try these google search terms: "excel macro sort data copy new sheet"</p> <p>Also, this might be interesting: <a href="http://ddalgleish.hubpages.com/hub/Filter-Excel-Data-to-a-Different-Sheet" rel="nofollow">http://ddalgleish.hubpages.com.....rent-Sheet</a></p> <p>However, you could end up with 365 of these sheets over the course of a year. Would that ultimately be meaningful to you? </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490064 Sat, 17 Dec 2011 16:56:53 +0000 Angela 490064@https://youlookfab.com/welookfab/ <p>If you want to have Excel find all the items that were worn on a given data and copy the names of the items into a new spreadsheet, a macro would work quite well. If you don't want to write a macro, then you could sort the columns according to the date and then copy and paste over the rows (items) that match your given date. </p> https://youlookfab.com/welookfab/topic/complicated-question-for-excel-geeks-wardrobe-spreadsheet#post-490029 Sat, 17 Dec 2011 15:17:36 +0000 Makrame 490029@https://youlookfab.com/welookfab/ <p>I wonder if any of our computationally gifted friends might know the answer to this question. I am now using a modified version of Kate's spreadsheet <a href="http://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear" rel="nofollow">http://youlookfab.com/welookfa.....t-you-wear</a> to keep track of my wardrobe. Basically, the first column has a list of all my clothes (at least those that are actively in use), then I have info on purchase price and dry cleaning or alterations cost (these all get added up to calculate the price of the item), then I have multiple columns where I enter the date on which this item was worn. A couple of columns are used to calculate (automatically) when was the last date something was worn, how many times total it was worn, and what is its cost per wear.</p> <p>Ideally, I would also like to keep track of combinations of items I am wearing and whether I liked them. Is there any way to have Excel find all items that were worn on a given date and then copy the names of these items into a new spreadsheet? </p>