Відео

Great Video, this was puzzling me a lot as to why I couldn't sort data once it was another column further in the Pivot Table, but now I've managed to understand thanks to your explanation. Keep it up!

Thank you so much

That's all well and good... how do you stop it showing the total number of pages, rather than just the number of pages in the section - i.e. if you choose the number format "x of xx" how do you make the xx be ONLY the number of pages in the new section?

Thank you so much! Solved a very frustrating problem!

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.

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?

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?

you are great

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

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

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.

thank you so much

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

u schooled me, thanx so much!

🎉

thankyou!!!

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.

Thank you! I was fighting with this for an hour

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

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

but this will not be interactive with slicer

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 😅

Super helpful, thank you!

thank you very much!!!!

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

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.

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

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.

Valuable information, thank you!

It is not working

❤❤❤❤❤

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?

Thank you for this. It was very helpful!

Thank you!!!

This is super helpful!

great

Great Explanation. Thank you!

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

Tks ❤

great, thanks!

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

You saved, thank so much

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.

Excellent. This was so easily explained.

Right on! You saved me so much time!

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

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.

This was Brilliant. Thank you for the massive help.

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.😂

thank you!