365

Hi, currently struggling with counting number of days based on dates taking data from a FILTER generated table: This is the Root Data tab: This Root tab is the root data tab showing vendor documents and their Revision Dates, Planned Submission Dates as well as Actual Submission Dates. And...

Hi everyone! I created a purchase order request from Jotform, but when I download the Excel file, all the information from the products come in one cell. I need the information to be allocated on separated columns and rows (example in the image below). I've tried using the replace tool +...

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

Excel allows us to retrieve currency quotes from Rifinitiv's database and populate a spreadsheet with the quotes. Using function XLOOKUP and some smartly laid-out tables, we can calculate all the cross-rates and their changes from the prior day's quotes. It's a simple process of refreshing the...

Hi all, I have a question on how to implement a line of code, selecting a specific cell value (and deleting a different one). What I mean by this is the following (see image): I have a range of time data points in a single column (either empty or not, in time format). Whenever there are two...

Hello, I am trying to copy some charts from one Excel file to another workbooks and to PowerPoint, for some types of charts I can paste special then paste link as Excel Chart Object in PowerPoint, But for charts like Waterfall the option is greyed out and disabled. I cannot paste as Excel...

Hi all, I am looking for an efficient way to calculate the error time from a sheet of data based on the name column (B). When the value of a certain error is 1, the error is started and when the value is 0, the error is solved (column C). There are a lot of different errors, which sometimes...

hi, I'm getting spill results on multiple columns from the below formula. =IF(R2:V2>0,"",O2) but I don't want spill results, I want results in a single column. This gave me a #value error. =IF(@R2:V2>0,"",O2) How can I sort it out?

Hi, I have a couple of customizing ribbons. I want to get all the customize ribbon & command details in excel cells as below. How can I get this? My all macros are saved in multiple modules in personal.xlsb file.

I'm trying to use spreadsheet compare. Sometimes it works fine. Sometimes I have that error message about the file being password protected. I'm usually trying to compare an autosaved file - when I'll open Excel 365, I get that box on the left 'do you want to save this'. I can't tell if the...

Hello, I'm using Excel for MAc on a 365 subscription, I have a workbook with multiple sheets, I would like to save all sheets as .csv using the standard comma separated values format. I've tried changing an existing windows script...but not quite working... Essentially I have data on several...

I am receiving this error: Run-time error '1004' Unable to get PivotFields property of the PivotTable class This is occurring for me in Excel VBA (version 2013), but the same code executes successfully on a different machine running Office 365. With pt .PivotFields(fieldName).ClearLabelFilters...

Hi friends, I am stuck in a VBA problem. actually, the code is printing the value twice in subsequent rows its working fine on my previous excel version 2007 but now I shifted to office 365 and its printing the values twice whenever the cell changes. Attached photo for clarification see timing...

Hi All, I have been using this code with success for generating emails, using VBA Set OutApp = CreateObject("Outlook.Application") Our company is moving to the web based Outlook email, Office 365. This causes the code to error Is there code which creates email when using Outlook 365? Any help...

Hi I would like to disable version saving in the current Excel product. This feature has caused me issues. For instance: If I want to open an Excel spreadsheet and work within it without altering the file, I do not want to have to search through versions/dates to find where I started to revert...

Using Excel 365, I am constructing vertical timelines by making scatter charts, following this method: https://www.vertex42.com/ExcelTemplates/vertical-timeline.html In that url, the first illustration shows the desired output; second one shows the simple data table. I am not using a...

Hi guys, Sorry to bother you, but I don't know if Excel is able to do this task, if yes it would be great. :) The thing is I have, for example, a list of values (1,2,3,4,5) and another list of values (A,B,C), is there any way, having this, to get these row combinations?: <tbody> 1 A 1 B...

Hi, I want to convert total days into months with a formula. More specifically 10 oct 1982 - 1 nov 1982 = 22 days ; How many months is this? And what is the formula? I researched many formula's but they round up the months into 30 days or 360days. Thank you in advance for your help.

Running Excel 365, and trying to change the color of one of the cell’s background color depending on the value within the cell. The cell contains a currency number derived from the sum of a series of deposit values minus the sum of a series of withdrawals. I want to have the cell background to...

I have been running Excel 365 for 3-4 months and have just ran into a problem with the move/copy function. I've had no problems with this previously in 365. Now every Workbook and every sheet has the move or copy selection grayed out and not accessible. Everything two days ago was fine, I added...