Recent Discussions
Using Mail Merge with MACROS
Hello, I am currently trying to use Mail Merge from EXCEL with a WORD document to be emailed in OUTLOOK The emailed document takes the form of a .pdf attachment Our designer has created a Customer Order Update document that requires a WORD MACRO to realise his formatting once the Merge has taken place. I have created a MACRO in the WORD document that is able to perform the correct formatting on the WORD document after the merge with EXCEL spreasheet data has taken place. However, with a multiple page document I find that the MACRO is only applied to the 1st page of the document Subsequent pages of the generated .pdf do NOT have the MACRO applied ( I have various detail lines that are hash preceded capital letters that trigger the MACRO to perform a subtitle substitution ) As the MACRO goes through 25 lines of detail (below the fixed document header) in a Loop to perform substitutions I wondered if expanding the Loop to 50 lines would allow the second page of the document to also receive the MACRO processing. This did NOT happen Please advise how I can get the MACRO to apply to every page of the mail merged document I do not believe that the MACRO can only be applied once to the 1st page of the mail mereged document only regards
Hyperlink and view the cell in different workbooks
Hi Experts, I'd like some help with this, i have 2 workbooks, namely Test 1 and Test 2 .. Excel file (Test 1) TEST 1 100 TEST 2 200 TEST 3 300 Excel file (Test 2) TEST A 300 TEST B 200 TEST C 100 I'd like a formula whereby if i click "100" cell from (Excel file 1) it should open the (Excel file 2) and take me to it's cell with same value as excel file 1. Thank you.
Conditional Formula?
I'm trying to make a conditional formula where if the logical test (=if(logical test) results in a number in another cell being greater the value of the formula cell returns a value with a color. Is this at all possible? i.e. if the value is higher the color is green if not the color is red
Word Document Using Columns Not Modified, But Suddenly Displays Differently
I am using MS Word on my Windows 11 desktop. I have been using a Word document that I created a couple of years ago. The document uses Columns. The last time I modified it was a year ago. I tend to print it out every two days. Suddenly, the document displays differently and prints those differences. It now displays vertical lines below four of the five squares. I moved the document to my Windows 11 laptop. Same problem there. I sent the Word document to my son who opened it on his Mac computer. On his computer, it displays exactly as it should -- No erroneous vertical lines. Again, I have not modified the document. I thought maybe a Windows update may have caused the problem, but I don't see any Windows update in about one month. I am displaying two images below, a "before" and "after" image. The "before" (i.e., correct) image shows five squares and the alphabet displaying vertically. The "after" image shows vertical lines below the first four squares. Can anyone suggest a fix for this? Repeating myself again -- I have not modified this file in a year. Thank you. Len Jacobson First Image -- Correct display of the five squares and the alphabet displayed vertically Second Image -- Incorrect display. Vertical lines appearing below the first four squares.
Grouping data sourced from another sheet in that workbook.
I am trying to make a monthly inventory count workbook through excel nut am having trouble consolidating the counts. I have a made a simple version of what I need but am getting stuck on the final sheet trying to group the data together. In my workbook I have a sheet with all my input data which I have attached below. I have fed this through PowerQuery so that the information from this Sheet can go into all other sheets on that workbook, and I only need to update one Sheet if new stock comes in, or leaves. From there I have the "Bar" Sheets where the counts get entered. As I will be dealing with a lot of stock, felt better to make a "Loose" & "Cartons" column and then just sure make an extra column where the calculations can be made giving a full total amount. Last Sheet is where I would like to consolidate all the totals from the "Bar" sheets into one area. which I have used the formula ="SheetName"[@Cell] as I do not know any other ways of bringing across this data. And here lies the problem. As on the "Full Stock List" sheet i have cells that are not actual values, the rows are not grouped, and if I try to sort by Item Name alphabetically, only the original 5 columns will sort, leaving the new columns untouched. If anyone can help explain how I can get around this, that would be most helpful, as I need to make this Workbook much much bigger.
Vlookup with If And statement
This one has me stumped but excel is awesome and I feel like this should be possible. Thank you in advance for any help! I'm not sure the best way to go about this, I'm thinking a vlookup with with nested if and statements between 2 excel spreadsheets. I have a slightly large spreadsheet with names that are repeating and events repeating thus the file first needs to determine the class so it pulls the right time. The data contains Classes (class A, B and C), Name, Event and Time. Spreadsheet A is the times. Everyone's times are recorded on Spreadsheet A. Spreadsheet B is to track the times per participant on a different tab per participant. In Spreadsheet A, column A is the participant number, column C is event name, column G is the time and column H is the class. In spreadsheet B, (the formula will be in Spreadsheet B). First, I need the formula to look at the class listed in spreadsheet B Column C Row 4 (Class A), then the formula needs to look at column H in spreadsheet A for Class A. Then it needs to look for the rider number on spreadsheet B, Column C row 2 (1234), needs to search spreadsheet A column A for rider 1234, and last it needs to look for the event (Runs) in spreadsheet B, and searches spreadsheet A column C for runs. After it matches all 3 then it needs to return the time in column G. If it does not find all 3 matches, then it needs to leave it blank. IE: Spreadsheet B, Class "A", Rider "1234", Event "Runs", if it meets all three criteria's then return the time in Column G.Compute elapsed time
I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work. It would have to account for the minutes where the start time minute is greater than the end time minute. Unless someone has another way of computing this.Contest Scoring
I created a spreadsheet to calculate points for a Skillathon test we give to kids at our fair. On the main sheet, we input the points earned for each question. I created a second sheet to calculate the points for question 20. I have a table set up to auto-sort the teams by Amount. I want to be able to take the points from this table and have that input into the main score sheet. Need help with the function for this.Activation failed
I have been running MS 365 on my Mac laptop for years with no issue. Suddenly I cannot save an Excel file. I saw the activation button, but activation failed with the code OxO....unknown cause. I cannot find any way to contact MS for support or chat. I checked on my desktop and I do have an active subscription. I am running Tahoe 26.5.2. Excel is 16.7.1. Any suggesstions.
Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)
I have scoured this forum’s discussions about hyperlinks in a copied worksheet referencing back to the original sheet. Perhaps I missed it, but I didn’t find a solution to my specific problem, so I will start a new discussion. Apologies if a community wizard already answered it. I have a workbook with monthly worksheets, each showing the transactions into and out of a savings account. Each transaction goes into (and out of) one of several “virtual” accounts to reflect the purpose for which the money is earmarked, like property taxes, travel, etc. (called Account 1, Account 2, and so on in the attached) Each month’s worksheet has a section of hyperlinks, each of which ideally jumps to a specific account in the same worksheet. The attached example contains only four accounts, but my actual one has 23 with 31 columns and 98 rows. So the hyperlinks are helpful in navigation. Each month, I make a copy of the latest worksheet and rename it for the new month. The problem: the hyperlinks in the new, copied worksheet reference back to the “source” worksheet. With 23 hyperlinks, changing each one’s sheet reference (Edit Hyperlink...) every month is not efficient. Question: how can I (efficiently) make the hyperlinks in the new worksheet reference cells in their new worksheet? These are hyperlinks that are internal to the workbook, not to external URLs, so DonBici’s Feb 21, 2024 suggestion of a helper column doesn’t seem like it would work in this case, and I am not advanced enough for his VBA suggestion. Thanks!Partial scoring for multiple choice questions in Forms
I am using Forms to create a quiz and have multiple choice questions and matching questions that are worth more than 1 point. How can I change the auto-grade from "all or nothing" to assigning points for each correct answer within that one question? If a question has 3 correct answers and is worth 3 points total but the students only selects 2 or the 3 then 0 points are awarded. Without manually reviewing each student/question answer, can auto-grade give a 2 out of 3 score?
Microsoft Word - Footnote remains on the original page after moving the original reference up
Issue I encountered an issue in Microsoft Word where moving the original footnote reference to an earlier location in the document did not move the footnote itself. The footnote remained on its original page even though the reference had been moved. This was particularly problematic because the same footnote was referenced multiple times throughout the document using cross-references. Cause The footnote is anchored to the original footnote reference in the main text. In my case, Word had somehow lost track of that original anchor, so the footnote stayed on its original page while all cross-references continued to point to it. Solution Hold Ctrl and click the misplaced footnote reference. Word jumps to the original footnote reference in the main text. Cut the original footnote reference (Ctrl+X). Paste it in the correct location using Keep Source Formatting. Press Ctrl+A, then F9 to update all fields. Verify that: the footnote has moved to the correct page, the numbering has updated correctly, all cross-references still work. In my document, one footnote had previously lost its connection to the original reference, so its numbering did not update automatically. That one had to be repaired manually. Important Do not create a new footnote or copy the footnote text itself. Move the original footnote reference in the main text. This preserves the existing footnote, its numbering, and every cross-reference that points to it. I hope this helps someone else. It took me quite a while to figure out what was happening.
Allow data Input but don't allow Edit
Seeking for some help again with these formulas. Have been working on project where multiple people are on the same excel sheet with scanners inputting data. The issues I'm running into is when people aren't paying attention and scan over existing data the information gets overwritten, we lose all that info. I currently have their scans matching another list of info (duplicate) it will go a certain color depending on its category. With that being said I was wondering if there is something I can setup to not allow any more changes if the info inputted was a match with another cell. This is an example of the info I use: So, if another person comes and scans radio 456 into the cell that has 789 instead of picking another blank. Now I will only 1 radio fully charge (456) instead of having both 789/456. Please let me know if this is possible.Runt-time Error 1401 When Importing a CSV file Using VBA
I am beyond frustrated that I cannot make this work. Let me explain. My spreadsheet needs to import a standard CSV file then parse that information into several different worksheets. The very first time I ran the import code it worked. The second time and every time after that it fails with the "Run-time error '1004': Application-defined or object-defined error" message. I tried this on a different computer with the same results first run it worked, every run after that it fails. Here is the code: Sub ImportCSV() Dim ws As Worksheet Dim csvFilePath As String Dim lastRow As Long ' Set the worksheet where you want to load the data Set ws = ActiveWorkbook.Sheets("Raw") ' Specify the path to your CSV file csvFilePath = "exportusers-all.csv" ' Clear existing data in the worksheet ws.Cells.Clear ' Import the CSV file With ws.QueryTables.Add(Connection:="TEXT;" & csvFilePath, Destination:=ws.Range("A1")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .Refresh End With End Sub This is the code I've found in numerous places when I search the internet when I search how to do it. I have tried this as a normal user and "Run as Administrator" both fail. My Trust Center > Macro Settings are as follows: Enable VBA macros - Selected Trust access to the VBA project object model - Checked The CSV file can be opened in a text editor and Excel without any issues, but if I try to import it, it fails completely. Any help or suggestions to resolve this problem would be greatly appreciated. Thanks.
Ruler Feature Disappeared from Microsoft Word on Android Tablet
Hello everyone, My father recently bought a new Android tablet specifically to use Microsoft Word for his work because he relies heavily on the Ruler feature. When I first installed Word, the Ruler was available and worked perfectly. However, after restarting the tablet, it disappeared. Since then, I have uninstalled and reinstalled the app several times, tried different versions of Word, checked all the settings, and confirmed that we had an active Microsoft 365 subscription, but the Ruler is still missing. My father has also tried adjusting to different document layouts and workarounds, but unfortunately none of them are practical for his workflow. He simply cannot work efficiently without the Ruler feature. Has anyone experienced this issue? Is the Ruler still supported in Microsoft Word for Android, or has it been removed? If it's still available, is there any way to restore it or install a version that includes it? My father bought this tablet mainly for Microsoft Word, so this feature is essential for his work. Thank you for any help or clarification.
Recent Blogs
- SharePoint Online is introducing a new tenant-level setting that allows organizations to choose whether heading permalinks should appear on SharePoint pages.Jul 14, 2026
- 2 MIN READPowerPoint is getting easier to use with new SmartArt, fresh themes, a cleaner Design ribbon, and a more modern file open experience.Jul 13, 2026
