excel

Hi , apologize if this question sound more difficult than it should be I would like to create a formula that is able to properly capture a certain amount of number and distribute as evenly as possible from total number in cell C16. The total delivery is 725. Im trying to figure out a...

I've been trying to work this out and searching multiple sources and forums to no avail. MY APPLICATION: We are an engineering firm. I have a "Special" Workbook that peforms calcaultions that need to have Iterations=TRUE to get past Excel throwing up an error. There is not, in fact, a circuilar...

I have noticed when using the conditional format screen, if I have scrolled left or right in the worksheet prior to opening the conditional format screen, my cursor click within a formula will not place the caret/ typing location where my cursor clicked. I seem to have to close the workbook and...

i have been trying to solve the following issue: i have a very long column of values (in this case there are only two values = FY23, FY24, with FY23 always coming before FY24) and another column values (all zeroes except one value >0 in an FY23 row and one value >0 in an FY24 row) i want to...

Hello, The below macro currently works perfectly and moves a line of data based on the selection from a drop-down menu (data validation list). I'd like to add a simple "are you sure you want to proceed" "yes" "no" style button message box when the user selects the item. Private Sub...

Hi, I'm hoping you can help. I'm trying to automatically add some values of a Bill of Materials. I have numbers in column A which represent the level in the Bill of Materials, column B is the price, column C is where to totals should go. The criteria is that if the next row is greater than the...

Hello, I am currently working on with a user form which has multipage tool, and each page has different tools such textboxes, combo boxes and checkboxes. This user form will be use as a data entry tool which will be populated into specific columns once the user click submit. Whenever I try to...

I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...

Hi I am trying to do a sumproduct as a dynamic vba code but I cannot get it to work. I'd use XL2BB but i'm on a work computer so i can't install anything, so attaching picture for some clarity. This is for an order form and the reason i want it dynamic is because the number of rows changes...

I have looked at a lot of different ways to do this and tried to incorporate their ideas into this sub but I keep getting different errors every time I run it. I am searching for "0" in the listed ranges of the STATUS SHEET and finding the offset value which is the vehicle number. then finding...

Hi VBA Developers, Hope you are fine, Please note I have been trying to create a database but in this case, I only need a column with the data, based on some parameters but during the process I am confused since the code I think should have some loops. Probably my code is a mess, but...

I have about 30+ hidden sheets. Normally on clicking unhide, a dialogue box opens. And suppose there are 8 sheets with sheet name starting with letter "C". To unhide specific sheet, I would continue typing "C" and then selection would move to hidden sheets with name starting with "C". I would...

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

Dear all, I am a new user of Excel VBA and try to use it to automize the daily working routine. Now I'm facing the problem of checking duplication and change the value. So basically what I would like to do is to check the order for customers and I would like to check whether there are...

I want to sumifs based on weeks of the month, the results should be for the month that is on top of "First week", displayed for "First week, Second week, Third week and Fourth week". Note: Column A is in text form, while Date is mm/dd/yyyy Number Date Amount January 2024 January 2024...

Hello! I have a workbook that lists products we sell, for who, when and how many we have sold of each product. I would like to add macro into workbook, which based on multiple criterias can figurate the exact matching and return the requested relevant information, what I need. To simplify my...

Hi I'm trying to find a way to automatically translate texts in Excel, but none of the functions I have found work. The company where I work seems to have many security levels so that's why I have limited options. I already tried the following ones: *Add-ins-> Blocked by the company *Google...

Hi Team, Greetings! I need a help here, I have created an excel template in which the workbook has n numbers of checkboxes. I don't want end users to do the right click and change the checkbox properties. I want to lock all the checkboxes so that users can only check or uncheck the checkboxes...

Private Sub Game_Num_Val_Change() Dim cntl As Control Me.Game_Num_Val = UCase(Me.Game_Num_Val) Set cntl = Me.Game_Num_Val Call VerticalAlignCenter(cntl) End Sub Public Sub VerticalAlignCenter(ByRef ctl As Control) MsgBox 1 On Error GoTo ErrorCode Dim MinimumMargin As Integer Dim...

I require a textbox to change the font size of text dynamically based on number of characters in the text Initially the size is 14 if no. of characters < 20 size = 14 if no. of characters > 20 and < 25, size =13 if no. of characters > 24 and < 30 size = 12