excel 365

For starters this cannot be in VBA the intended users are not familiar enough with VBA to maintain the document. That being said im 90% of the way there. I have one cell with 2 or 3 number values between 1 and 35 and another cell returning all the values that are inside that cell. My only...

Dear all, best regards I am trying to convert numbers to letters (in Spanish) with the help of some formulas, I have used the range of numbers between 1 and 999. The formula I am using seems to work but not quite right, since it gives results for any number greater than 100, but when I use a...

Dear beast regards I am working with some figures on the number of people in a country, classified according to sex. I want to carry out sums taking into account specific age groups, for example Men between 2 and 10 years old (Men_2 - Men 10)...

it is a bit complicated. excuse me! I have raw_report which contain teacher name and daily attendance for student on each subject. In template, i wanna make a button so that my colleague can click and generate the score of their student base on daily attendance. First, it need to look "Team...

Hi @all, I would like to implement the following function in VBA as a procedure. =INDEX(Zones!$G$3:$S$273;MATCH($A3;Zones!$C$3:$C$272);MATCH($B3;Zones!$G$2:$S$2)) I have two sheets ("Data" and Zones"). I search in the sheet Zones for zone numbers, to be able to determine later also the...

ABCDEFGH1ColorHexadecimalColor CodeRGBRGBName Color2#0048BAAbsolute Zero3#B0BF1AAcid green4#7CB9E8Aero5#C0E8D5Aero blue6#B284BEAfrican violet7#72A0C1Air superiority blue8#EDEAE0Alabaster9#F0F8FFAlice blue10#C46210Alloy orange11#EFDECDAlmond12#E52B50Amaranth13#9F2B68Amaranth...

Hello, I have a sheet in a file which I would like to update automatically with changes. the problem is the file name changes everyday in the format of "AAAA01232022" to "AAAA01242022" so the change is in "mmddyyyy" format and progressing by one each day. Occasionally there are days the file...

Dear all, have a very happy beginning of the year. I am carrying out a code in VBA, I am novice in these subjects, the idea that I am trying to develop in the worksheet 1 is to show the different options of colors that Excel has available (or at least of which until the moment I have...

Dear cordial greetings I am learning the basics of Excel's VBA language, and I have come across the issue related to the default color range. Investigating in different sources I have found a code that allows to obtain the values for the RGB primary color palette, presenting them all together...

Dear all, have a nice day. I appreciate any information you can give me about the following question. I am performing a search process that allows me to find, within a set of students [A2:A9], who obtained the highest grade [B2:I9], for a set of subjects [B1:I1]. I found a solution, but it...

Ok, so this is a follow-up to a previous thread which I thought I had solved and turns out I was just really tired and not paying attention to what I was doing. Apologies for re-introducing the question. I have 4 tabs worth of information: 1) Site information (Named table: T_Branches)...

Hi, I have one destination workbook open on PC#1 (Windows 10) The workbook has links to two source workbooks open on two networked (wifi) laptops (Windows 10) PC#2 and PC#3. I'm using the current version of Excel 365 (on all three computers). For the cells of the destination workbook to be...

Dear all, have a very nice day I apologize for the lengthy statement, but I want the problem to be well formulated to avoid confusion. In the 'Data' worksheet, you will find information that compiles the weather conditions recorded daily for any given city from January 1, 1999 to December 31...

Cordial greetings I have two concerns and they are as follows. The first one is, in column A are registered 6 States with their respective cities, the name of each State is in capital letters, now, I need to extract in a separate column (can be for example column L) only the names...

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