excel

Hey all, It's not exactly related to VBA and excel, but I hope this has enough relation to it. I wrote a .bat file. The purpose of this .bat is to watch a folder for new files, and if so, call a VBA command. :loop dir /b "%folder%" > nul 2>&1 if errorLevel 1 ( timeout /t 30...

I am working on a VBA file that has a button, which should upload some data from an Excel file to a Sharepoint file. The problem is when the Sharepoint file is open it takes 2/3 times to run it to upload the information. But I want the data to be uploaded whether Sharepoint is open or not. This...

Hoping someone can help. I have a worksheet that i need to remove or add a cell range(s) (red border area) from the 1st row down the column to a specific point (Stop Line) which can change dynamically. The more ID's added or removed in the rows will push the Stop Line down or up. Also, the more...

Hi All, I am running a basketball league and need to make the results and standings easier to see with minimal input. I have all the results as they should be using the NBA format. However, I want the spreadsheet to tell me the position of the team automatically based on win %, conference...

I have 5 main sheets and want to freeze pane lines starting from sheet 6, row 7, column 2. What do I have to do? Thank you.

Hello, I have used solver to optimize the sum of numbers given certain constraints, however I am now trying to optimize the product of numbers given certain constraints. When finding the optimal sum I can use a binary list to select the combination of item to sumproduct together to find the...

Hi all We have a shared Excel file in a Teams channel. Everyone has the channel set as a Onedrive shortcut too, so it creates a daily backup of itself on the first opening each day using a Workbook_Open script. This script also sets a temporary view so people don't mess up what each other is...

I have a table with many values (lots of rows) and I have to copy values from each row (highlited in yellow) in some specified cells. Each of those rows will give me a result which I have to copy in another cell. Once this process is done i have to repeat it for each row of the table. The...

Good morning ! I am in need of assistance with coming up with a formula that’ll provide me with an 2 month and 5 month evaluation dates for work without counting a summer period. (05/31/24-08/11/24) So let’s say a Hire Date is 01/01/24 2 month would be 03/01/24 5 month would be 05/01/24 But if...

Hi Excel community! I have a table where I would like to be able to format the value of the [Process] column according to the value of the [Type_Cli] column, as shown below: Case [Type_Cli] is 'F' -> Format shoult be : "P000000000"; Star with Letter 'P', followed by nine digits' Case...

Hi to all of you, I have an excel sheet with an Inputbox, where i'm asker to put the number of the month, the year and a third value. Problem is, it was working as intended during 2023, but now, it's swaping the month for the day. I'm in Europe, we use dd/mm/yyyy and I'm trying to make the...

I need to create a “workcopy” of a workbook with many worsheets. Once created, I need to update the workcopy manually to upload changes and redo powerqueries etc from the workcopy is this possible and if so how to do it with or without macros? Thank you

We have a table of invoices with 17 columns in. I have a combo box which populates with the Tenant's company names in and then an invoice number combo box which populates with ONLY the invoices relevant to the tenant selected in the TenantComboBox. However I need the InvoiceNoComboBox to only...

Good afternoon all, I will try to explain this as best i can forgive me if this comes across as a bit muddled. As you will see in the image, in Column A i have a list of items, and Column B check boxes, in the Corresponding merged cells i have a formula that runs a Vlookup which works...

Good morning, Im looking to find a way to center check boxes in the cell they are placed, presently i have a check box list and id like all the check boxes to be in the center of their respective cell, is there a way to do this either with or without VBA? My check boxes start in Column C, Cell...

I would like use a vlookup or equivalent to pull the latest comment for a specific ID. I can’t figure it out. I’m thinking maybe MAX but I’m not using it correctly. I think i need the vlookup because I am filling in cells in another table with the latest comment for its ID. In this example I...

I've been toying around with Lists as my boss tasked me to update our data input from Excel. Lists is cleaner-looking and more corporate. I can get behind that. Thing is, in my Excel file, I used macros extensively, but one key element was to check in other sheets when data was entered, and if...

Why doesn't Excel create a new formula that allows some simple programming language logics like LOOPS, FORLOOPS. i.e =LOOP()

I want to achieve the following results, How can I do this without VBA, only formulas? Output: Actor Movie Result Actor Desired Result Movies Actor 1, Actor 2, Actor 3 Oppenheimer Actor 1 Oppenheimer, Barbie Actor 1 Barbie Actor 2 Oppenheimer, Spiderman Actor 2...

I have 2 sheets Form_ERR and DataBase_ERR. Form_ERR has: - Cell L11 - where a number can be entered Cell L14 - dropdown selection containing Names Cell L16 - dropdown selection containing Categories Cell L18 - dropdown selection contain Departments Cell L20 - dropdown selection containing...