for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers

Bowman 🇸🇪 Oct 2022 6:22am, 14 Oct 2022 1,847 posts	0 Bowman 🇸🇪 Thanks UM, I give those things a try too. Maybe I have to start all over and modify the code a bit. I mean it’s a pretty basic thing I want to do.
jelly Oct 2022 6:40am, 14 Oct 2022 3,907 posts	0 jelly I love excel, but rusty though! Just passing through
Bowman 🇸🇪 Oct 2022 9:50am, 14 Oct 2022 1,848 posts	0 Bowman 🇸🇪 I think i got it to work UM, at least for now, have been doing some testing and it works in different scenarios. Basically i check if my "folder variable" has a value and in that case move the letters, otherwise it don't. This is because the variable gets "nothing" if it doesnt find the right attachments. Strange that other people got that code to work in that state. Oh well, lets see how it works out.
JK chameleon Oct 2022 9:17am, 15 Oct 2022 17,030 posts	0 JK chameleon This is likely to be utterly basic (sorry!) How do I make a drop-down so that my reckless Admin can only put pre-set options in a column of cels? Can I do this without tackling VB? And will this continue to work on spreadsheets shared via MS Teams? (You can go back to the super-complex stuff now!)
um Oct 2022 9:19am, 15 Oct 2022 6,623 posts	0 um support.microsoft.com Is that what you want?
um Oct 2022 9:55am, 15 Oct 2022 6,625 posts	0 um This one is a bit more step by step. exceljet.net You can also, in validation, just check against a source list of values without the drop down.
SPR Oct 2022 10:21am, 15 Oct 2022 38,527 posts	0 SPR Second link sounds like overkill for what JK described. A simple list is what is described in the first link, the second link is making a drop down that changes based on a previous answer.
SPR Oct 2022 11:24am, 15 Oct 2022 38,528 posts	0 SPR Sped up the file I created earlier in the week by doing a check for number of line items open in a month per client and only letting the array run if there were multiple lines for a client.
JK chameleon Oct 2022 3:36pm, 15 Oct 2022 17,032 posts	0 JK chameleon Thanks um. The first one was what I was after, but the second one has given me some ideas!
larkim Oct 2022 11:18am, 24 Oct 2022 19,426 posts	0 larkim Is it possible to format a pivot table such that calculated fields stack on top of one another? Almost like having a column presented as a row?