combine code

I have 3 macros that are sequentially connected. I am trying to merge them all into one macro. I am missing something but I can't figure out what so I thought i'd try here as a cheat. My first macro collects a month's worth of data. My second macro consolidates taht data and sends it to a new...

Hi All, I have the following piece of code that will round value (positive and negative values) to the nearest 0.5: For i = 33 To 35 With Sheets(1).Cells(i, 14) If .Value <> "" Then .Value = Application.MRound(.Value, Sgn(.Value) * 0.5) End If End With Next For i = 12 To 21 With...

Hello, I am trying to combine a couple of simple VBA Change codes but am unable to get both working at the same time. The one coded first works, the second doesn't. Private Sub Worksheet_Change(ByVal Target As Range) With Target If Intersect(Target, Range("A:A,F:F")) Is...

I am in need of getting these two codes to work together on the same worksheet. Any ideas? I've tried several tactics from searching online but i'm missing something somewhere. The two codes I have are: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo myerror If...

Hi all, I am trying to combine sections of code to achieve the following: I have three worksheets: “raw data”, “completed” & “quote”. All workbooks have the exact same layout The header takes up row 1 Data fills column A-H. H is a status column with a drop down list, here you can select : “raw...

Hi all. I have two private sub: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target Range("F7:F14")) Is Nothing Then Exit Sub Application.EnableEvents = False With Target .Offset(, -2).Value = Offset, -2).Value - .Value End With Application.EnableEvents = True End Sub...

Hi All I am going to start from scratch here Do anyone know how to create a macro that will combine all files (xlsm) in a folder and save but for 89 separate folders??? eg I have Folder1, Folder2, Folder3 etc 89 in total Each folder has files Folder1A, Folder1B, Folder1C etc (xlsx) I want...

I have a workbook with two worksheets in it. In one worksheet called Materials List I have multiple rows that when selected, automate into the other worksheet named BOM. In the Materials List tab, I need columns H and I to combine (not sum, just combine descriptions) into column C in the BOM...