If i delete one the of sheet, then can delete the corresponding sheetname row data? e.g delete sheet "May", but at the sheetlist the "May" row have contain other data or information at column E, F, G.
@clkinfo4 күн бұрын
Very very very thankyou so much i find many way to do this but no one have good way!!!
@evanshearin64904 күн бұрын
Thank you! This was so helpful!
@ibrahim826497 күн бұрын
I tried this process but got an error on the first flow ( Launching outlook) the application has failed to launch outlook.
@ExcelMoments6 күн бұрын
Is Outlook properly set up on your PC, and can you launch it manually?
@ibrahim826496 күн бұрын
@@ExcelMoments yes it is, actually I tried it this morning and it worked 🙂 as figured out how to include attachments 👍. Thanks for the tutorial
@ibrahim826497 күн бұрын
This is a great tutorial, what if I had attachments for every recipient ?
@zidanmohiuddin16327 күн бұрын
kalar baccha
@ExcelMoments6 күн бұрын
What does kalar bachha mean?
@Kevin-g3g1v8 күн бұрын
SMART
@ExcelMoments7 күн бұрын
Thanks for the kind words
@simonec989 күн бұрын
Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
@pavanthakur57599 күн бұрын
How to do the same in Gsheet?
@ExcelMoments6 күн бұрын
I am no googlehseets expert but this should do it =MAP(A2:A9,B2:B9,LAMBDA(x,y,TEXTJOIN(", ",1,SORT(transpose(XLOOKUP(SPLIT(x," "),SPLIT(y," "),SPLIT(y," "),""))))))
@JorritScharloo11 күн бұрын
Thank you, Victor, for demonstrating how to circumvent the limitations of textsplit. Finally found a solution to sum textjoined arrays (syntax 1|2|3/4|5|6 ) from certain rows within a table! I am very happy.
@kaylendao964711 күн бұрын
Thank you sir! This is exactly what I have been looking for!
@ExcelMoments11 күн бұрын
You are welcome ma'am
@mohamedsoffar443413 күн бұрын
Thank you for these 43 shorts playlist
@ExcelMoments6 күн бұрын
You are very much welcome
@Neoscarface634213 күн бұрын
Top g
@Woodpile6316 күн бұрын
Thank you! I love simple tricks that accomplish difficult manual operations!
@ExcelMoments6 күн бұрын
So do I. You are welcome
@Shroomtomb18 күн бұрын
God send - thank you!
@ExcelMoments17 күн бұрын
@@Shroomtomb You are welcome
@tobiadekoya377418 күн бұрын
Thank You. This is really helpful.
@ExcelMoments17 күн бұрын
@tobiadekoya3774 You are very welcome
@jinnellesiew143919 күн бұрын
Save alot of my time .... thank you
@ExcelMoments6 күн бұрын
You are welcome
@EarlyLALY23 күн бұрын
Thank you so much sir!!!
@kadher_mh27 күн бұрын
Is there a way to go back to the "Before" version?
@ClemenDK28 күн бұрын
I have been sitting with multiple functions and lists, helper columns etc., and chatGPT as aid to no avail, and you basically solved the entirety of my project in one formula requireing only minor tweaks. Amazing, thank you so frikkin much dude <3 <3 <3
@H4XOR2328 күн бұрын
Hey I tried to implement it but it didn't work, can you please let me know your email? So I can give you spread sheet and you can send me one with macro in it I tried multiple times hence I'm thinking of sending you spreadsheet,so please let me know your email we'll communicate over there.
@Perun0001Ай бұрын
Saved my life! Thank you! If anyone is struggling just pause at 0:21 and don't use the + on the right side of your keyboard for me it didn't work, just the one on the top.
@jazzista1967Ай бұрын
Victor... Great video.. not only your content is great but also your video production... Great tips on the Hyperlink function and that shortcut ALT left arrow to go back to your original cell. Thanks for posting!
@ExcelMomentsАй бұрын
Thanks Luis for the feedback. You know i love hyperlinks 😂
@christopherbenton4643Ай бұрын
You are the best! Got a new subscriber off of this one. I wish I would've found your video sooner, watched 30 plus minutes of other videos over explaining things and describing multiple scenarios. You were concise & I appreciate your help!
@ExcelMomentsАй бұрын
Thanka for subscribing and for the kind words. Glad you found it useful
@miladarastoueian2874Ай бұрын
Very Good
@ExcelMomentsАй бұрын
@@miladarastoueian2874 Thank you
@stanleyroot9622Ай бұрын
Brilliant, clear explanation. Fully agree with previous comment!! - you change my life with this tutorial. love u so mach man!!! Why on earth excel hasn't turned this into a standard function for such a common question, is beyond me.
@ExcelMomentsАй бұрын
Absolutely agree with you. With LAMBDAS, you can create your function that does this exactly, but I am with you totally, a native function will not be bad
@claudiaayala9654Ай бұрын
Absolutely brilliant thank you so much.
@ExcelMomentsАй бұрын
You are welcome
@TejasRai-w8vАй бұрын
Is there any possibility to write a VBA code to automate persons availability check (time slots) using outlook scheduling assistant like checking free/busy or by any other method?
@KinseiVenusАй бұрын
thanks LEGEND
@ExcelMomentsАй бұрын
@@KinseiVenus you are welcome
@AronCassell-k8oАй бұрын
Great video thanks, got it working for what I was looking for. I do have one question at 3:36 for example you add the array and get F3# all i get it a fixed A1:A6 for example I assume I am missing something.
@jazzista1967Ай бұрын
Why this video only has less than a thousand views? It should have more than 10 or 100's thousands of views. This is a brilliant approach of on overcoming the limitation of the textsplit function when working with 2 arrays at the same time. Thanks again Victor.
@ExcelMomentsАй бұрын
@@jazzista1967 I wish i knew why it does not have a million views! 😀😀
@karandhiman4385Ай бұрын
How do we use delegated account if we want to?
@jazzista1967Ай бұрын
Man... i miss your videos and your humor! HAHA!
@jazzista1967Ай бұрын
Victor... how are you doing? I started to watch more of your short videos... i have not seen you posting much content lately.. i will catch up with your regex examples today. I hope you are doing well. Take care!
@ExcelMomentsАй бұрын
Welcome back! Hopefully I can get back to video creation very soon
@jazzista1967Ай бұрын
VIctor Good morning. Good to hear from you my friend. . Look foward to your new upcoming videos.... Take care and stay safe!
@liyanakananАй бұрын
thank you for the help!
@ExcelMomentsАй бұрын
You are welcome
@santoshkoyada2 ай бұрын
Thank you.. It was really helpful
@crismurguia71402 ай бұрын
So simple, yet never thoght about this solution. YOU ARE A GENIUS
@ExcelMoments2 ай бұрын
@@crismurguia7140 I will give the credit to Bob Umlas
@leerv.2 ай бұрын
Ok that is pretty awesome! One more reason to love XLOOKUP() hahaha. Thank you!
@ExcelMoments2 ай бұрын
And many more reasons 😁😁
@Sup3r872 ай бұрын
Hmm, in excel for me "find and select" is a much smaller menu and there is no "go to special". When I press ctrl+G I also get a "go to" window with no "special" button and again with a different appearance. Seems like Microsoft removed the feature - very annoying.
@ExcelMoments2 ай бұрын
What version of Excel do you use?
@Sup3r872 ай бұрын
@@ExcelMoments I use the web version through Microsoft 365 - I ended up "solving" the issue by deleting the entire array and re-inserting a new one, then making the modifications I wanted to again lol.
@ankursharma61572 ай бұрын
Thank You!
@ExcelMoments2 ай бұрын
You are welcome
@sd6472 ай бұрын
legend
@ExcelMoments2 ай бұрын
Thanks so much
@luislozano42512 ай бұрын
Is there any way to add a blank row without number? For example 20 21 22 23 24
@ExcelMoments2 ай бұрын
when you say without number? I am not really sure what you mean
@luislozano42512 ай бұрын
@@ExcelMoments Every line has a number at the left, at the beginning The same for columns (letters) A B C D E F 1 2 3 4
@CullyCulls2 ай бұрын
You just saved me hours of manual labor, thank you! Quick question, is there an object I could add to the vba script that would identify if the comment thread is "resolved"?
@ExcelMomentsАй бұрын
Apologies for my late response You can do something like this ws.CommentsThreaded.Item(I).Resolved, it would return a Boolean (True/False) depending on whether the thread had been resolved or not
@jhastie2 ай бұрын
Thank you SO much for this. I did not realize that the key was to also include the change in the Currency tab. Hallelujah!! I can't believe I finally have a solution to this, and it's thanks to your video. I've also told ChatGPT to include that in its explanation to users.
@HarpreetGujral272 ай бұрын
Can we do same through Power Automate Online? Actually, am unable to find similar step in online version.
@IvanCortinas_ES2 ай бұрын
It is absolutely essential to have a thorough understanding of how these functions work. Many of the problems we face are data modeling problems and these functions solve these difficulties. Thank you for the explanation.
@IvanCortinas_ES2 ай бұрын
All the proposals are excellent. Thank you Victor.
@ExcelMoments2 ай бұрын
@@IvanCortinas_ES You are welcome
@lottieg47062 ай бұрын
Thank you for this.
@ExcelMoments2 ай бұрын
@@lottieg4706 you are welcome
@BigHatBoris2 ай бұрын
Blowing my mind mere seconds into the video. 🤯🤯🤯🤯🤯🤯🤯🤯