office 365

  1. B

    Combine multiple Excel files into 1 then refresh the query

    Hi everyone, I have been having a really hard time to figure out what I am missing. The goal: I have need to allow multiple business to fill out an Excel sheet privately then have that data flow into a single master sheet that I maintain. This is to overcome the constant copying and pasting...
  2. A

    How to Extract all Data of Same Repeated Lookup Value Using XLookUp (No VlookUp)

    I have the below data set when i select the Department I want to get a table wih all the employes working in thhat department like this Only Vlookup formula can be used to obatain the result table. Kindly advise. Thanks for the Help in advance
  3. A

    How/which formula can be used to lookup a value in a table and return multiple matches in table format In Excel?

    I have a dataset like below when I select Department from the Dropdown I need to return multiple matches in atable format like below Which Formula can i use to get these multiple matches in a table format....Thanks in advance
  4. R

    Refresh button to reconcile sheet names based on cell values and adjacent column text

    Hello! I'm trying to create a function which will be assigned as a macro to a "Refresh" button which will read values from D3:D59 and color the tabs based on associated cell value based on matching string text in Column B. For example: It would read the names of all tabs that match with their...
  5. R

    change a cell value and corresponding sheet/tab color based on value on button click

    Hope everyone is having a great weekend! we go. I have a button on several sheets in a workbook which is supposed to call one function. The function is supposed to look at a sheet named "CONTENTS" and search column B for matching sheet name. Eg. If the active sheet I'm working on is...
  6. T

    Cannot Find Correct O365 Sharepoint Path For Excel VBA

    I've been trying to create files from Excel to our company SharePoint site on Office 365, so far without success. Here is the code: Dim dYear As Double Dim sYear As String Dim sDC01 As String Dim sDC02 As String Dim sDC04 As String Dim sDC05 As String Dim sDC06 As String Dim sDC11 As String...
  7. A

    Excel showing pasted text when double clicking on another cell

    Hi On of our users has a problem which has been going on for a while now. When they copy a piece of text from the same excel spreadsheet or from something else like a filename etc, they paste it into an empty cell in excel. Excel freezes after that, then if they double click on a cell that...
  8. D

    Export to PDF macro fails on Excel Office 365, not on Pro Plus 2019

    Hi, I have a button inside Excel workbook which exports certain pages to PDF with one click on a button. The Excel version I am using is Professional Pro Plus 2019 and my customers version is the same build, but an Office 365 version. If I hit the button in my version it works, but if my...
  9. E

    VBA Pivot Table Run Time Error 5 Invalid Procedure Call for Office 365

    I have this macro with the lines below (this is also the highlighted part when error is encountered) that previously works on win7 - ms office '10 and '13. But in win10 office 365, it errors out with the message invalid procedure call - runtime error 5. I've found some online like changing the...
  10. L

    Splitting multiple choice entries from Microsoft Forms in Excel without text to columns

    Good morning all, I am using power automate to automatically populate a spreadsheet with results, those results would then be fed into a pivot. You might be asking "why not just use Forms' visualisations?", well the person wants to only view submission results week by week and might get asked...
  11. R

    Formula using INDEX and MATCH

    I am using the following formula in a spreadsheet to autofill cells with data from another sheet and it works. =INDEX(Table15[Global ID],MATCH([@Name],Table15[Name],0)) I am using the same formula in another workbook and I keep getting a syntax error. =INDEX(Table15[SAP...
  12. C

    Conversion to 365 killed External Data Connections

    My company converted to Office 365 today. I use a lot of external data connections in my Excel files. After the conversion none of these work. Most are connecting to a server vs a mapped drive. Is there a way to get these to work without redoing everything? Thanks! Crystal
  13. T

    Are these bad coding? What is slowing these down?

    Can someone please help me? After I upgrade Office from 2010 to Office 365, all the codes become very slow. I'm looking into the causes. I came across this really simple codes and pulled out a section. I wanted to ask all of you experts why these simple codes would take such a long time to run...
  14. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
  15. M

    VBA - PIVOT table data transfer to new worksheet

    Hello I wondered if you could help. I have just started to learn how to use VBA to help with data management in excel. I'm using excel office 365 on windows 10. I managed to create a macro that processes the raw data into a pivot table filtered to a set format (lets call this sheet 1). Within...
  16. K

    Replace 2 values from 2 different tables at once

    Hi, It's my first post here. I have 2 tables in Excel that come from VBA data extraction from some other software. I’d like for the common values in the NAME column on each table to be linked, meaning : if, for instance, I replaced ABC02 in the second table with ABC03 then the first table’s...
  17. C

    Programmatic access to Office VBA project in Office 365

    Hello everyone, I have a workbook that I built in Excel 2013 which contains some VBA code requiring programmatic access. I sent the sheet to a user who has Office 365 along with instructions to allow programmatic access that I found at...
  18. N

    Obtaining data from webpage into Excel via VBA code

    Trying to extract SOFR rates and dates from US Fed Bank website, using excel sheet to drive the dates (basically all data from 1st April 2019 to present), back into the same excel sheet to link into other formulas and...
  19. rediffusion

    How to backup settings of Microsoft Office which are in registry branches?

    Cross-post! CloneApp - this is a software that allows you to copy/backup the desired registry branches. Want to understand how from the registry backup what I need (I just do not know where to look, there are a lot of things written) !? Settings - ContextMenuCell, ContextMenuPly...
  20. T

    Sending emails to multiple recipients with multiple PDF files via VBA & Excel

    I'm very new to VBA and found a code online that sends emails to multiple recipients but can only attach 1 file per email. I cannot find a code that works wherein it goes to a specific folder and attaches all PDF files that are stored in the folder and goes to a different folder and does the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back