Пікірлер

• 
  @LauraWestley-pm1kd7 күн бұрын

  Thank you so much! Solved a very frustrating problem!

• 
  @bekirkatranciАй бұрын

  Misleading, it's not a treemap from pivot table, it's treemap from regular table pasted from pivot table which doesn't work when pivot table is refreshed.

• 
  @BeeDeeF49Ай бұрын

  Help! I am having such a hard time adding a space after a colon to over 2700 lines of text (it's a script). I don't understand why I can find double spaces after a period and replace them with a single space, but can't find a single space after a colon and make it a double space. it just won't work. Can you help?

• 
  @paulsteel8739Ай бұрын

  In outlook 2007 you could create a menu dropdown and have a list of templates/macroes under each button? IS there anyway to do that in 2019 please?

• 
  @shyiramberegilbert1452 ай бұрын

  you are great

• 
  @letitiastrathman65852 ай бұрын

  Thank you so much! I have been spending some time trying to figure out an easier way to access my template!

• 
  @muhammadajanmosaye63672 ай бұрын

  Hi dear, Why is this not possible in the mac?

• 
  @devote22562 ай бұрын

  I love how the spreadsheet functions. But the end goal was not accomplished due to "Your organization data contains 12 entries that are not in the organization..." error. I see some others have experienced this.

• 
  @turgachiniganesan57142 ай бұрын

  thank you so much

• 
  @enorma292 ай бұрын

  shoutout to those of us still using non-CC photoshop instead of current photoshop's AI magic

• 
  @ImadetheCake3 ай бұрын

  u schooled me, thanx so much!

• 
  @ameenullahusfzi62463 ай бұрын

  🎉

• 
  @adrianeland873 ай бұрын

  thankyou!!!

• 
  @Kashifnasir893 ай бұрын

  problem I am having is that, I am using a kindle template and I have pasted text in it, now I think, although its one document but it has several sections and page numbering makes no sense. i need an easy way to start numbering the whole document like it had no sections or complications.

• 
  @bisongc20924 ай бұрын

  Thank you! I was fighting with this for an hour

• 
  @adwThatsMe4 ай бұрын

  This is ingenious! This will greatly help me; especially since they keep removing features from templates with newer versions.

• 
  @williamwhite45124 ай бұрын

  I have created a dynamic range that works. But how do you include blank cells. If a cell is blank, then the formula doesn’t work on the next row

• 
  @sunnygawande52834 ай бұрын

  but this will not be interactive with slicer

• 
  @adamk32444 ай бұрын

  Very cool. Thank you. But if I don’t want the graphic, how do I just get that info to show up in the big blue box? Have tried everything in Visio studio 😅

• 
  @gabl34005 ай бұрын

  Super helpful, thank you!

• 
  @user-nc5ow1st6c5 ай бұрын

  thank you very much!!!!

• 
  @vicentemoll36185 ай бұрын

  Sub GetFormData() ' Note: this code requires a reference to the Word object model Application.ScreenUpdating = False Dim wdApp As New Word.Application Dim wdDoc As Word.Document Dim FmFld As Word.FormField Dim strFolder As String, strFile As String Dim WkSht As Worksheet, i As Long, j As Long strFolder = GetFolder If strFolder = "" Then Exit Sub Set WkSht = ActiveSheet i = WkSht.Cells(WkSht.Rows.Count, 1).End(xlUp).Row ' on this line, notice that the file extension is .docm. ' if you are using .doc files or .docx files, make sure ' you change this line to match up with that. ' strFile = Dir(strFolder & "\*.docm", vbNormal) While strFile <> "" i = i + 1 Set wdDoc = wdApp.Documents.Open(Filename:=strFolder & "\" & strFile, _ AddToRecentFiles:=False, Visible:=False) With wdDoc j = 0 For Each FmFld In .FormFields j = j + 1 WkSht.Cells(i, j) = FmFld.Result Next FmFld End With wdDoc.Close SaveChanges:=False strFile = Dir() Wend wdApp.Quit Application.ScreenUpdating = True End Sub Function GetFolder() As String Dim oFolder As Object GetFolder = "" Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose the folder", 0) If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.path Set oFolder = Nothing End Function 'If you decide to use Content Controls instead of Form Fields '(which are found under the Developer Ribbon), you'll need to find every instance 'of FmFld and replace it with CntCtrl. ' Dim CntCtrl As Word.ContentControl 'For Each FmFld In .FormFields changes to For Each CntCtrl In .ContentControls 'WkSht.Cells(i, j) = FmFld.Result changes to WkSht.Cells(i, j) = CntCtrl.Range.Text

• 
  @user-lw8sy2om2i5 ай бұрын

  Move whatever field you want to sort by to the first column, collapse all columns, then you can sort by any data field. Then expand to see the other fields.

• 
  @msatyaprakash5 ай бұрын

  Thanks a ton. I found an instant solution and learning that's been pending..

• 
  @playtone2296 ай бұрын

  Whenever I try to add a section, it selects ALL of the slides after the slide where I inserted the section. And I don't see a way to edit the slides under a section.

• 
  @joaogrilo48966 ай бұрын

  Valuable information, thank you!

• 
  @lasboters6 ай бұрын

  It is not working

• 
  @GmailCom-hh6yq8 ай бұрын

  ❤❤❤❤❤

• 
  @HappyGirl7078 ай бұрын

  Great video but I am having hard time restarting page numbers on new section 2. The first page of section two is 1 but then the second page of section 2 still says one? I have deselected the link as previous. Can you help please?

• 
  @user-zz2mh9bo7j8 ай бұрын

  Thank you for this. It was very helpful!

• 
  @mxa0wuk8 ай бұрын

  Thank you!!!

• 
  @VivianUang8 ай бұрын

  This is super helpful!

• 
  @francescovalente3019 ай бұрын

  great

• 
  @Mohammed_Emam9 ай бұрын

  Great Explanation. Thank you!

• 
  @b-rad269910 ай бұрын

  1:41 is where they show you where and how to find the setting…

• 
  @thanhthuy952810 ай бұрын

  Tks ❤

• 
  @FishnetChicken11 ай бұрын

  great, thanks!

• 
  @surfdoc1111 ай бұрын

  How do I get the instructional text back if the filled-in text is taken out?

• 
  @IS-7711 ай бұрын

  You saved, thank so much

• 
  @Thaliasnowe11 ай бұрын

  I hope you can get back to me. Everything worked fine but the page numbering on section 2 starts at 1 but there are no numbers on the following pages. Example 1...2...3...4..so on.

• 
  @Thaliasnowe11 ай бұрын

  Excellent. This was so easily explained.

• 
  @SFGUNNER Жыл бұрын

  Right on! You saved me so much time!

• 
  @maverick19_ Жыл бұрын

  Hi Neil, thanks for this - how can you use a treemap so that when data changes, the tree map also automatically updates?

• 
  @Naveen299 Жыл бұрын

  Thanks its very help. Also could you explain how this category rules can be executed automatically to all in coming emails. Instead us press run now option each time.

• 
  @sarahassan2067 Жыл бұрын

  This was Brilliant. Thank you for the massive help.

• 
  @psychologicalprojectionist Жыл бұрын

  Genius! But I still can't understand why Microsoft makes it so painful to use templates. It baffles the mind. I remember using templates in Lotus Notes decades ago and it was so easy. It has only been lately when I've considered using templates in Outlook to discover actually copying from old emails is often easier.😂

• 
  @plasebox Жыл бұрын

  thank you!

• 
  @farogatolimjonova9566 Жыл бұрын

  Thanks for the video! I want to use it for my weekly task, where I send out 15 emails to different distribution lists. I think pinning 15 templates makes no sens, right? What would you recommend in my case?

• 
  @21babyjoker Жыл бұрын

  I just removed the second volume sorted the totals and re added the the other row filter

• 
  @bkaley8974 Жыл бұрын

  Not much help since the categorize button does not even show or is found. Everything else does, but no categorize. Outlook 21.