excel

I am trying to do an array multiplication, multiply each of the months with the corresponding numbers from the 'Array' below, for example for "Person 1" do 0.1*150, then 0.2*250 and so on. As you can see it is returning #VALUE. Even if I try multiplying as an array, or multiply the numbers one...

So I have a two part question. I am struggling to understand how to incorporate multiple worksheet changes into one sheet. I have seen the examples for using IF NOT INTERSECT, but cannot correlate it to my needs. I also have a formula that I need to run in multiple rows and is the second part of...

Hi, Been a while since I've been stumped, and I'm sure its easier than I'm making it out to be I want to highlight the cells C2:H5 based on if the row header is within the time range A:B relative to the row of coarse Any help would be great, i know i ts a conditional formation by...

Can someone help me with dashboarding? I've got data where you can see who (Column 'Plant') did something during the month. I need to easily see during the month who did something that month/this year. And I want to easily see/select where it is not going great during the month/year. This data...

Good afternoon.. 1st Post: Helping out a friend with a mentor program, but I need help compiling live data from 100 sheets into one sheet. Here is what I have: I have 100 sheets in a Microsoft Excel workbook (saved to a OneDrive folder) that use identical column headers in each table. See...

Hello! I am new here and I hope you can help me as I am a noob when in comes to macros. I have a macro that I want to create that can list down all the file name and the file path of each item inside a folder. I also want this macro to list the items inside a subfolder. Note that there is also...

Hi all. I am looking to create a VBA which generates alphanumeric values( numbers and caps letters) based on user input. For example if user says 15, 15 random alphanumeric values need to be populated with a max length of 35 in column A. Column B should populate 15 random alphanumeric values...

Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...

Our Excel files are stored on SharePoint Online and they are very picture-heavy. Some files reach 300MB and we need a way to reduce the file size. If I run the Save As command I can get to the tools menu to compress images and bring a 300MB file down to 100MB, but how do I do this with VBA? I...

so hello, I am using beta M365 Excel and I am working on some sort smart solution for some. What would be great is to get Python code that generates path to a desktop ( or at least Windows username ) My problem is that I tried: # importing os module import os # using getlogin() returning...

I want to make this formula: =sum('MTD Data'!S11:U11) dynamic. =MATCH(A11,'MTD Data'!$B1:$B,0) returns the number 11, so instead of S11:U11 I want to take something like sum('MTD Data'!S(MATCH):U(MATCH)) that automatically returns S11:U11 What way is there do it?

password a sheet or workbook but I still like to use Highlight like yellow or RED if I password the sheet or workbook I can not use Highlight

I have the following table that is loaded automatically I need to somehow create a table that relates the part number and components at all levels, returning the result as below.

Dear Community, I request your support with the following program (I have reviewed the posts in this forum, but could not find the right one for me). The program should create URL, send request to webpage, get webpage title, process webpage title, write processed data to file, apply hyperlink...

Hi , Want Regex in excel formulae as mention below input and output for reference. Input Output 3005AB1394714000000 AB139471 2022ABR52447FPV ABR52447 2022A9561554PPV A9561554 2022ABR52240LTW ABR52240 2022PAR45939FPV PAR45939 2022PNN03733FPV PNN03733 2019Z6167512 Z6167512...

Hi all, i have a quick one, looking at the attached screenshot in h16 i have MAX looking at e10-f10 returning the highest number. i want to get the percentage from that column for the line i'm on if that makes sense :) Happy friday everyone! Dan

Hi all, I need a VBA code in excel for the following: If I use “inputbox” and I want the text in a cell, there are two buttons. Ok and cancel. If I fill in text and click ok. The text will be filled in in the cell. Thats good. If I leave the text empty and click ok, the cell will be empty...

I am in need of a formula which will search for a specific value in a column of cells that may contain more than one value in each cell. e.g. A B C D E F 1 ROLE RESULT ROLE RESULT 2 897 BONUS 563, 897 BONUS 3 167 #N/A 4 897 BONUS 5 637, 598, 897 BONUS 6...

Hi, I have a VBA project. There are two Userforms. On the first Userform, I chose some of them to be enabled and input a value in the respective text box. Then when I press the Next Button, it should control which Labels are enabled and which respective Text boxes have value so it should copy...

How do I detect "optimize for best display" option on Microsoft excel using VBA? Searching does not give any answer except through reading registers.