office 365

Hi i have an macro that saves a pdf and then emails out statements. But on conversion from 2013 to 365 it no longer works. Could anyone have a look over the code and see if they can see what the issue is i.e. whats changed between versions that i need to update? Any help appreciated. Sub...

Hi, If someone can help me find a way to remove or hide the time and date stamp from 'comments' in Excel 365, it will be much appreciated. I am using the comments function to add regular updates to individual items in a workbook and am applying a date against each update in the comments field...

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

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

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

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

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

Hope everyone is having a great weekend! Ok...here 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...

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

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

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

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

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

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

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

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

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

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

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

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