vba & code

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

I'm stuck with how to select the Gender (Male / Female) from a dropdown list in a Website. My current script works, apart for the gender part: Sub MERF() Dim IE As Object Dim doc As HTMLDocument Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate...

Hello All, I have been trying write a VBA code for protecting all sheets except the column H. The spreadsheets consists of from ListObjectsTable and slicers. every vba code i have tried locks the slicer. So i was thinking rather to protect the sheets i could protect the ListObjectsTable except...

Hello, so first of all - this is not about dependent dropdown lists - The dropdown lists in my excel file are already dependent from each other. What I would like to know if it's possible to automatically change what is set in one dropdown when changing something in an other one. I do have a...

quiero pasar una base de datos de excel a powerpoint pero cada vez que se genera el archivo se crea en las mismas diapositivas , quiero que se haga en el orden de la base de datos en la misma diapostiva Opción explícita Sub Combina Correspondencia() Dim strBaseDatos como hoja de...

Hi; I am asking you and my dear friends and professors to help me I have two sheets in the attached file One sheet to enter and edit information and another sheet to store information I encountered a problem editing information in this file I cannot recall and edit the information I have...

I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is...