Recent Discussions
Got in over my head, now I need formulas to get the right data.
A program creates an excel spreadsheet that has 2 columns, I need to know out of the 51 possible location points in column A, which ones are missing. And list those in say column D. This sample is obviously missing -001 and -002 so I'll know the result is correct when at least those 2 are there. Thank You, Walt -028-Floral Shop Wooden Post-028 37 -014-Sub Shop/Pizza Area-014 35 -021-Bakery Cold Case Area-021 34 -026-Produce Cold Case Salad Pkg Area-026 34 -025-Produce Cut Fruit/Veggie Area-025 33 -023-Produce Cut Veggies Case-023 33 -027-Produce Cold Case Organic Case Area-027 33 -024-Floral Portable Cutting Machine-024 32 -015-Marche/Soup Area-015 31 -010-Indoor Seating Area #2-010 29Vlookup help
I have done the basic Vlookup to get data from one page to another, my Excel skill is just above beginner. I created this skill matrix and I was wondering if is possible to create a page where if i enter the name and last name of the employee ( we have some siblings and relatives so both conditions have to be meet) I will display all the Employees operations where there is a number and the number so it will look like the back of a baseball card. operations Last First Role MRP Setup Troubleshooting Inspection op1 op2 Filter name1 lastname1 machineoperator1 name2 lastname2 machineoperator2 2 name3 lastname3 machineoperator3 1 name4 lastname4 machineoperator4 name5 lastname5 machineoperator5 4 name6 lastname6 machineoperator6 1 name7 lastname7 machineoperator7 3 3 name8 lastname8 machineoperator8 1 3 name9 lastname9 machineoperator9 1 name10 lastname10 machineoperator10 2 3 3 name11 lastname11 machineoperator11 1 0 0 0 3 2 name12 lastname12 machineoperator12 name13 lastname13 machineoperator13 name14 lastname14 machineoperator14 something like this: name11 lastname11 Role: machineoperator11 MRP 1 Setup 0 Troubleshooting 0 Inspection 0 Thank you in advance for any guidance
Why does SUM not work for me ??
My worksheet has been generated by VBA from another master worksheet. By filtering data, and copy/paste. I am using office 365, and a simple =SUM(A2:A4) of 3 numbers (5,10,5) on that page does not work. It just displays 0.00 All the cells are formatted as a number. Any ideas please
About Combining Tables in Mutiple Sheets
Hello, I would like to combine all 3 tables in tabs "2024 12", "2025 01" and "2025 02" into CASH REPORT tab. I want to link the following columns in "2024 12", "2025 01" and "2025 02" to CASH REPORT's table A/C NO., EFFECTIVE DATE, CURRENCY, DEBIT/CREDIT, DESCRIPTION, EXPENDED DESCRIPTION, AMOUNT Please see the attached sample spreadsheet. Is there a better way than copying and pasting the columns manually? Thanks.How do I Stop Word Switching to Multiple Pages View
I have a high resolution wide screen monitor. Every time I open a Word document in full screen, it switches to the Multiple Pages view (typically 2 pages, side by side). I hate this view! I can't read 2 pages at a time. I always want a single page view. Does anyone know if there is a way to stop Word changing to this view? I am using Microsoft® Word for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bit
How to hide "Updated 1 item" in SP Online Document Library Web Part.
Hi, I added a Document library web part to a page and selected the folder that I needed for that web part. I also selected the "Video Gallery" view which was formatted using JSON. However, when someone clicks the Like/Unlike button, a notification appears saying "Updated 1 item" as shown below. Is there a way to hide this notification?Automated Grocery List
Hi, I'm trying to build an automated grocery list where I have a table full of recipes and then another table where I can select meals for the week. Based on meal selection, i would like to populate a list of groceries using the recipe table. My issue has been with getting this grocery table to work correctly, i'm not sure how to output results into another table that is dynamic. example of meal selection table example of recipe table I want to be able to have all my ingredients for selected meals summarized by category and total quantity
Alternate to SUMIFS array assistance
Hello, everyone. I apologize for asking yet another SUMIFS question, but I haven't been able to find a thread anywhere (so far) that offers a sample similar to what I'm trying to do. I have a spreadsheet with 3 tables located in separate sheets: SKU, Production, and Expected. In the SKU table I have a list of item codes that are part of a general Category. In the Production table, I pretty much have a manual log of the number of Units that I produced in different Dates for each Item Code that applies. In the final table I pretty much just have a table with the Dates. The file I uploaded has a total of 4 columns in this table, but in my actual document the last 3 columns are actually arrays. I just placed them inside the table for purposes of this example. Anyhow, columns B-D are the Categories each Item Code belongs to: Blue, Green, or Red. What I'm trying to do is as follows: I'm trying to do the equivalent of a SUMIFs formula for Blue, Green, and Red. It first checks that the date in the Expected sheet matches the date in the Production sheet. Next, it checks in the SKU table which Category the Item Code belongs to for the selected date. It then adds the total Units for each Category column. I've tried with variations found online of SUMIFs and SUMPRODUCT, but I haven't been able to make them work. Any and all help is greatly appreciated.
How do I connect my computer to a printer wirelessly?
I have a printer located in a different room and I want to connect my computer to it. I use a windows 11 computer and the printer is a HP OfficeJetPro 8028e. I'm going to also use this in a project for my class where I need to use a forum to solve an issue.Retrieving multiple values from a field to select attachments to a report generated email
I have a report that is based upon a query. The query draws its data from several tables. A command button on the report generates an email which has X quantity of attachments. The attachments are a function of the value of one field. The code I used successfully is: Dim O As Outlook.Application Dim M As Outlook.MailItem Dim Brochure As String Select Case Group Case "UniSet" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\UniSet\UniSet 190122-1334.pdf" Case "TwinSet" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\TwinSet\TwinSet 040423-0915.pdf" Case "CEL-4" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\CEL QuadSet\CEL-4 V30801.pdf" Case "CEL-32" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\CEL MultiSet\CEL-CEW MultiSet 271023-1014.pdf" Case "Strobe/Horn" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\Strobe Horn\S-H Series Strobe Horn 300623-0626.pdf" Case "Pioneer Solo" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\Pioneer\Solo\Pioneer Solo v230831-0931.pdf" Case "Pioneer Duo" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\Pioneer\Duo\Pioneer Duo V230831-0925.pdf" Case "CEL-LS" Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Acme Brochure Template\CEL-LS MegaSet\CEL-LS MegaSet V1.23.07.05.pdf" Case Else Brochure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Price Book\2024 Acme Price list Ver 1.pdf" End Select Set O = New Outlook.Application Set M = O.CreateItem(olMailItem) todayDate = Format(Date, "DDmmYY") todaytime = Format(Time, "HHMM") If EmployeeID = 1 Then Extension = "MMK" Else Extension = "GT" OrderEntryProcedure = "C:\Users\micha\Acmeprod\classeur_detecteurs-gaz - Documents\Sales\Quotes\Order Entry Procedure.pdf" FileName = Application.CurrentProject.Path & "\Quotes" & "\Q" & OrderID & Extension & " " & todayDate & "-" & todaytime & " " & ProjectName & " " & CompanyName & " (" & LastName & ")" & ".pdf" DoCmd.OutputTo acReport, "Quotation", acFormatPDF, FileName, False With M .BodyFormat = olFormatHTML .HTMLBody = Msg .To = EmailName .Subject = "Quotation " & OrderID & " for " & ProjectName & " Product ID: " & ProductID & " " & " Model " & Group & "" & concatenatedValues & "" .Attachments.Add FileName .Attachments.Add OrderEntryProcedure .Attachments.Add Brochure .Display End With Set M = Nothing Set O = Nothing End Sub This code works great for the first record of the field Group, but it does not show the values for subsequent records. My questions are: How do I get the values of not only the first record but all subsequent records for field Group How do I then run the Select Case command on all of the values of Group? Does it involve creating a string that counts the records and then having a loop run the Case Select? Dim attachments() As String attachments = Split("C:\File1.pdf,C:\File2.docx,C:\File3.xlsx", ",") For i = LBound(attachments) To UBound(attachments) If attachments(i) <> "" Then On Error Resume Next .Attachments.Add Trim(attachments(i)), 0 If Err.Number <> 0 Then End If On Error GoTo 0 End If Next iUse Data Loss Prevention to Stop Copilot Chat Processing Documents in Its Responses
The DLP policy for Microsoft 365 Copilot blocks access to sensitive files by checking for the presence of a sensitivity label. If a predesignated label is found on a file, Copilot Chat is blocked from using the file content in its responses. The nicest thing is that the DLP policy prevents users knowing about sensitive information by searching its metadata. https://office365itpros.com/2025/03/20/dlp-policy-for-microsoft-365-copilot/Facilitator Agent Brings AI-Powered Notetaking to Teams Chat
The Facilitator agent can make sense of the messages posted to a Teams chat and summarize the discussion and extract to-do items and unanswered questions. It’s a very practical tool that allows chat participants to focus on the ebb and flow of a conversation instead of pausing to take notes. A Microsoft 365 Copilot license is required before you can use AI Notes in Teams chat. https://office365itpros.com/2025/03/18/facilitator-agent-chat/Dynamic data validation based on another column in table
I'm trying to get the data validation (values from another table) dynamic, in a table and based on the value in another column. I manage to get all values from my other table in data validation using =INDIRECT("TableName[ColumnName]"). But I like to filter the values by the selection in the target table. I've asked ChatGPT, but it only leads me in circles - so now I hope for you super users in here! 😏Excel automatically and randomly changes workbook relative links to absolute links.
Hi everyone, I am working with sevral large workbooks that are linked together (total over 110 Mb of data). Periodically, I do backups trying to copy all workbooks together to another drive hoping that all workbook links will follow and refer to the appropriate files in the same drive (relative links). Recently, Excel started randomly changing my relative links to absolute links by adding the mention "file:///" whenever a workbook link appears in a formula. We are talking about hundred thousands of formulas and different links that I can't change manually. Once in a while it works (copying the files all together to a different drive or forder) maintains the relative link but sometimes it doesn't and then, the links change to absolute links in the copied and in the original files. Any idea ? Thanks,
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. The Microsoft 365 Community Conference is your chance to keep up with AI, build game-changing skills, and ta...
In-Person
Recent Blogs
- Boost your productivity with Microsoft 365 Copilot! Discover how to crush your daily tasks and save time.Mar 14, 2025
- Are you managing Microsoft 365 environments and looking for quick, reliable setup information? Introducing Microsoft 365 Setup Expert, your go-to AI-powered solution that helps you streamline Microso...Mar 13, 2025
