microsoft 365

Hi Everyone, I am trying to pull out list of my cheque deposits based on date it has been deposited, i have full list of deposits but i want only list based on the date i have provided on Daily Cheques Deposit sheet. Since, we deposit multiple cheques in same date so, i am unable to pull out...

Hi again, Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. I have a formula but it uses the "OFFSET" function and I need to do this without volatile functions in Excel. Thanks in advance! Ex 2024-11-18 2024-05-12...

I have a sharepoint list where items are input from a form (List1) and another list with users and emails (List2). I want the flow to check whenever an item is created in List1 and look up in the List2 and get all the emails that are classified as Admin in the column Profile and send an email...

Hello everyone! Does anyone know how can I extract Excel information for M. Copilot in Teams? I developed a chat bot in Teams for Finance team and we would like to add a feature so the user can ask for the status of an invoice and the bot can go to the Excel file and get the information...

Good evening. I am using Excel to track the progress of supplier onboarding. I have a cell that calculates the # of days elapsed using the following formula; =IF([@[LAST ACTIONING DATE]]="","",TODAY()-[@[LAST ACTIONING DATE]]) I also have conditional formatting set up to change the text bold...

Good evening, I am building a supplier onboarding tracker in Excel and need a pivot table that shows only the supplier names (column F) using the data in column AG. Is this possible or is there an easier way? ABCDEFAG2VNIPACM_IDSM_ID - ARIBATILE SELECTIONSUPPLIER NAMETRR...

I believe that this was asked over a year ago, and the response does not seem to be valid for Win10 and MS365. After creating a certificate with slfcert.exe I am being told that the certificate is not trusted and must be added to the Trusted Root Certification Store. A prior answer sass that...

HI, not sure if this is the correct place to post. I need an office script to create a change log because users are accessing the file by the web browser the VBA code now doesn’t work which does exactly the below. Date and Time Cell that was changed. Old Value New Value Hopefully, someone...

I have a macro that allows me to delete certain rows based off a specific text value from a specific sheet only, this seems to only work as long as I am active on the sheet named Apple however I want to be able to run a macro enabled button while I am on a different sheet and I keep receiving an...

Is there a way to turn C4 into a formula that actually performs a sum range of the result produced by the formula that's already in the cell? Referencing C4 in a sum range from another cell works (for example, [SUM(INDIRECT(C4))] in C5 produces the correct value of "0"). But is there a way to...

For years I've used the same code to insert pictures into cell comment boxes so that the image will pop-up when curser is over that particular cell. We were updated to Microsoft 365 and now it's inserting blank images. Sub PictureIntoComment() 'Inserts picture into cell comment. '(1) Paste...

Is it possible to reference a math sign like plus (+) or minus (-) in a formula from another cell in excel? Example, I want to add values of cell A1 (Value: 2) and B1 (Value: 3). Cell C1 has plus (+) sign. So, my formula should be =A1&C1&B1 and the result should be 5. This of course is not...

I am currently working on an integrated set of workbooks, where I need to transfer data values between workbooks. In order to do so I need a VBA Macro that can copy non-adjacent cells (ex. the locations of the cells are J4, J8, J12, J16....etc) and insert it in the other workbook with a...

I have two sheets in my workbook pertaining to this question. Sheet 1 - The full list of sellable products with their profit centers, classes, descriptions, ..., amount in currency. I won't be able to use xl2bb to copy a portion for you to see, so I've included a picture. Sheet 2 - A subset of...

I am trying to learn how to create custom ribbon in Excel just for my knowledge. I am trying to create ribbon similar like Home tab. But my vertical spacing is not like home tab. Picture can shown in details for better understanding about my issue. Also I am trying to find out how can I create...

I am working in Microsoft Office 365. ABCDEFGHIJ3Part NumberPurchase DescriptionSupplierOEMOEM Part NumberCostOn HandBldQtyPurchase RequirementsExtended4010-001Cord, power, 18 AWG, 5-15P, 9.84 ftDigi-KeyQualtek312010-01$7.00 4.0051 $ 7.00 5035-001Switch, pushbutton, SPST, 3A...

Hi Folks, Basic aim I am looking to automate the adding of new email folders to Outlook 2016 for new jobs that come into our office. We are using Microsoft outlook 2016 through a MS 365 contract on an exchange server controlled by Microsoft. Detail I have created an excel model for...

Hi all, I found the below code on another forum that will loop through files on a normal windows machine with a network location. However I am using a mac and i was wondering if anyone knows how to amend the code so it works on a mac. Sub Macro1() '//Change the path to the main folder...