vba & code

Hi all, I'm chasing a VBA macro urgently but don't know how to go about it. Thanks in advance, please see below: There are 3 documents, I have links to them below: Doc_1: Loading Google Sheets Doc_2: Doc_2.xlsm Doc_3: Loading Google Sheets What I require is a VBA macro in "Doc_3" which when...

How do i retain it from changing my formulas into Values. The only value change should be (i, 14) or Column N Option Explicit Sub btnStk_Click() Dim rData As Range, arrData Dim i As Long Dim sName As Long Dim sNote As String Set rData =...

Hi All, I'm self taught and have some pretty big knowledge gaps. I'd like to compare the Column A in my "Master" worksheet with Column A in my "Compare" worksheet. If a number is unique to Column A in my "Compare" worksheet I'd like to extract the information from the row and enter it into my...

My VBA macro runs reports from Excel to generate a Word doc with upcoming deadlines/due dates. However, I can't figure out how to include a description of the upcoming deadlines/due dates when I run macros. Here are the columns that I need help with: COLUMN A = MATTER NAME COLUMN K = TASK...

In a userform, I will select one product (of 300+), and a image appear... and I have all pictures put in another userform and multipages (can't use a folder as this have to be shipped to and from different computers and people). In my userform I can make the correct path to the image visible...

Hi anyone, I would like to match this 2 table as shown: Using the reference list, match the master list and return Column D to Column G. However the placement of the return has to be of the same position as the master list. Condition 1: If the code number of the reference list (Column D)...

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