excel 365

Good day I need some help. I am trying to calculate the cumulative grades obtained by each of the students (5), in each of the subjects taken (9). For example if I select student Abby (D17) from a drop down list and I want to know her cumulative grade recorded in chemistry (D18), for cell D20 I...

Hello cordial greetings I am new, I hope I am not making a mistake at the time of posting. I am a bit confused, I need to perform a data validation in cell C7, so that the days correspond to the month set in cell C6 and the year found in cell C8. The data is recorded in the DATA tab; I have...

I am trying to import data from an Access database into a PivotTable Report in Excel. The instructions I have are not matching up with what is happening in the Excel program I am using. I have Excel 365. I am able to get to locate where to import "Get" the data from Access the issue is how do...

I am having below formula: =IF(ISNUMBER(SEARCH(@CELL("contents"),B4)),MAX($A$1:A3)+1,0) In older versions of excel before 1902 it is working as expected but in the later versions of excel 365 @ is getting added before CELL and formula is not working in it. I have tried to replace '@' to ''...

Hey everyone, I have been reading through tutorials and threads and seen solutions for automatic scheduling, but there are so many conditions I need to consider I'm not sure if what I want to do is possible in VBA. I have attempted to write out how the logic will flow (not in VBA yet, just in...

Hi , I have managed to write this VBA code, where in to delete the string named "Do Nothing", across all the sheets in the workbook. code without looping each sheet it's working. However, After Inclusion to loop across the worksheets, it's failing to loop through all the sheets, instead only...

Good morning, I have the below code that cycles through a drop down, prints to PDF, and output saves into a specific folder. However, I want to be able to put a number in a cell, J4 for example, so that it only prints the first X number to PDF then stops. For example, if there are 100 items in...

Below is some of the code from a VBA macro. Currently when this runs it saves all newly created docs directly onto the desktop. Instead I would like for this code to create a named folder onto the desktop and save the files within. DesktopFolder =...

Hi everyone. I asked part one of this question and it was answered quickly. HOW CAN I FIND THAT THREAD SO I DON'T DUPLICATE IN THE FUTURE?? (uggh....sorry) Goal: I have a 365 macro to save the file as a XLS file, then a PDF. Someone (thank you to that person!!) answered the question, but now...

Hi, I have a data source in the following format with date, hour and Month derived from the @Timestamp per hour field @Timestamp per hour Count of records date hour Month 01/04/2021 00:00 8 01/04/2021 00:00 Apr-21 01/04/2021 01:00 12 01/04/2021 01:00 Apr-21 The data is used in a pivot...

HI, so my issue is as follows. I have a master workbook in which I would like to track changes that were implemented in other workbooks in dofferent locations. The workbooks are all including the master saved in different locations on sharepoint. Now what I would like to track are changes in...

I've been using Break links for years, and it always worked seamlessly. I'm now on Microsoft 365 Apps for business, and I find that it no longer works as expected on some files. What I've done is gone to Data - Edit links, and selected Break link, as I always did. After doing this, "Edit...

Hi, I want to generate 20 random numbers between 1-80, but my formula always bringing duplicates also. So is there any way to generate 20 sorted numbers in ascending order without duplicates and I want to save those numbers at runtime. it will be easy if the formula can generate numbers for 100...

Good evening, I have the below sub that is set to hide all Tabs with a name that ends in h. I would like to modify it to use the same button to Hide/Unhide all tabs that contain a word instead of ends with a letter. Option Explicit 'Set tab naming convention to hide & unhide Const TABNAME...

I'm trying to create a sheet with some intervals in each row. The total of sums of the intervals of each row must be 08:00. But I'm having problems, because the excel doesn't calculate each row at time, but every row simultaneously, and the total in each row ends in a value different of 08:00...

Hi Folks, Does anyone know a way to prevent excel from 'copying a tab mark' as well as the 'string inside the cell' when you copy a cell by: right-click, copy (i.e., instead of double-clicking on the cell and highlighting the string, then copying it). For instance: if the following string was...

Hi all, I hope some of you experts can help me with this. I am trying to put together some VBA code to automatically select a source workbook from a Teams (Sharepoint) folder based on a couple of variables (folder name and filename suffix) that are provided within the cells of my destination...

Hello everyone, I need an easier way to copy cells within a certain range and then paste in the same range as values. It's just that once the cells are filled with info from the index/match, I want to paste it as values so that the values don't change (it's people records and they might move to...

Hi all, Vers office 365 (with xlookup) I am already going to implement the formula from this thread Drop Down lists but I am struggling on some mechanics of my drop-down list as I have many conditions. I want the drop-down list journey to be: Internal/External? -> Provider name -> Target...

I have a list of 2,200 spare part descriptions that need to be shortened to 40 characters. Will someone please help with a formula that will do this?