vba & code

Hello my fellow Vba coders My worksheet contains a table where I want it filtered based on two separate dropdown list. The user will first filter cell B3 where the table filters the data accordingly, and then if they choose to, by selecting a value on cell B6, the table filters the information...

Hi guys, can you help me. I need a macro for this problem. Thanks in advance! :)

Hello Team, Looking for VBA support to complete the one automation. I have one shared drive (web-based) folder and every day there will be one file will be saved in this drive. I need to move this file to an input folder (define the path) and after moving the file that file data should post...

Hi, I have a market analysis sheet which is shown in the picture. As seen in the picture i have a column "p:p" where i can type in a date for each row. I want to make a code that colors the whole row green if its less than 1 year to the date, yellow if its more than 1 year but less than 2 years...

I have 2 sheets one with Item numbers the other with Zip Codes. I need to build zip codes for ever item number. One Item number might have 1000 zip codes, or only 2. Item 1 - 45801 Item 1 - 45802 Item 1 - 45803 Like so. The finished Item and Zip needs to be on a new sheet. This is going to...

Hey guys! I have been working on a project for a while to automate a task for my work. Final steps now, but for some reason my code is not working as it should, even if I try different versions. Sub InsertColumnsAndLabel() ' Select the "YT" sheet Sheets("YT").Select ' Insert 4...

Sub Pytagoras_two() Dim j As Integer, k As Integer For j = 2 To 6 For k = 2 To 10180 Cells(k, j + 9).Formula = "=int(trunc(SQRT(" & Cells(k, j).Address & "^2 + " & Cells(k + 1, j).Address & "^2)))" If Cells(k, j + 9).Formula > 36 Then Cells(k, j + 9).Formula =...

If any cell on Sheet1 B2:F2 match any cell on sheet 2 B2:F2 then highlight the duplicates on sheet 2 If any cell on sheet1 B3:F3 match any cell on sheet 2 B3:F3 then highlight the duplicates on sheet 2 If any cell on sheet1 B4:F4 match any cell on sheet 2 B4:F4 then highlight the duplicates on...

Hi, I am trying to make better, so instead of A = Range("B2").Value B = Range("B3").Value C = Range("B4").Value E = Range("B5").Value F = Range("B6").Value G = WorksheetFunction.RoundUp(Abs(A + (1 + (B / C) * (E - F)) / 2), 0) Range("B2").Value = G I am trying to use this Cells(2, 4).value =...

Como protejo automaticamente uma linha com base em uma célula? Exemplo: se você inserir um valor na célula E1, ele protegerá automaticamente as células à esquerda da linha, D1, C1, B1 e A1 E o mesmo se aplicaria às linhas seguintes, se você inserir um valor na célula E2 ele protegerá...

Hi, Given a UserForm with a TextBox named TextBox1 The textbox will feed data to an excel table using the following code: Sheets("Data").Range("Data_Start").Offset(TargetRow, 6).Value = TextBox1 We would like the user to encode 6 numbers example 123456 that would show in the table as...

Hello everyone, I need a macro code that can help me to combine pdf files based on the first 11 digits of each pdf for example in the current screenshot you can see the folder contains approx 900pdfs even though the names are different but there is a common id for each employee I.e. 1000133-001...

Hi i want ti edit my data by using if and when i run the code it just go to first line and skip the others Private Sub CommandButton1_Click() Dim LastRow As Long Dim NewRow As Long LastRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row For NewRow = 3 To LastRow If Sheet1.Cells(NewRow...

Hi all! I'd like to do a timetable so I can easily manage my projects and I need help to complete my macro. I have a combobox where I'd like to select the year. I also have many dates (one can be repetative) in a different sheet in column "A" (with header) that I'd like to use as the source of...

At Name creation, Excel defaults to Workbook; which was fine when intended with only one sheet. Now after finishing all the formulas, I have new need which requires Sheet duplicated to same workbook. What I need is help on, preferably non-programmatically, is all Names to remain same for...

I am creating a tracker that will be used as a live sheet. It will be accessed by numerous people and consistently updated. There will be an active tab and a closed tab. On the Active tab, the cells on row N contain a drop down. The drop down options are "In Progress" and "Closed". The goal is...

Hi All, I need assistance on how to efficiently delete blank and empty columns based on a condition in the second row, starting from "F" column to the last column. I have updated the entire project code information in columns F1 to the last column, totaling more than 150+ columns. In the second...

Hello everyone, I have been learning a lot from this amazing forum and have come across many short codes and new techniques. Recently, I created a macro code for Team Entry Preparation. However, I noticed that the code takes more than 1 hour to run when dealing with a large dataset. I believe...

Hello all I'm learning new things as I go and appreciate any help. I will have multiple sheets that are identical. I want to pull all the data from the sheets to the master at the end of the day. The sheets will be named C1 and C2, and this will be in reference to the work cell where the product...