icol

Hello everyone, I need to fill a tables with certain formulas, and so far I used the following approach: Range("E6").FormulaR1C1 = _ "=FORECAST.LINEAR(RC[-2], OFFSET(INDIRECT(""[Flight_A.xlsx]""&R5C5&""!$N$2:$N$70""), MATCH(RC[-2],INDIRECT(""[Flight_A.xlsx]""&R5C5&""!$AL$2:$AL$70"")...

Hello, I have a macro that splits one workbook into multiple based on column A (The provider). I want only the first 25 rows or less of that provider and some have less than 25 and others have over 200. I tried a count and still can't figure out the exact code. Im a newby somewhat to VBA so...

Not sure if this is possible.. but I already have a change event in a work sheet - works as I want it to Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Range("G17:G205") If Not Application.Intersect(KeyCells, Range(Target.Address)) _...

I need to insert a blank row if the left, 3 does not match. the code below, does not separate correctly. Application.ScreenUpdating = False Dim iRow As Integer, iCol As Integer Dim oRng As Range Set oRng = Worksheets("doc1").Range("A2") iRow = oRng.Row iCol = oRng.Column Do ' If...

Hi all, I have found a million solutions to highlight differences, but I'm having trouble finding something that accommodates the addition of a row in the middle of my data. The idea is that I have two sheets with a few dozen columns--let's call these sheets A and B, with B being the newer...

I am working on a UDF that may be more complicated than I can handle. (sigh) The UDF is called just once from a single cell in the only sheet in the only open workbook. I have break point (F9) set at the top of this section of code: . . . Dim iCol As Long Dim RBestI As Variant Dim...

I am working on a UDF that processes a large table of data. A small example might look something like this. <tbody> R/C W X Y Z AA AB AC AD 24 $100 4.5 A Y B33 3/22 250 2005 25 $250 5.8 C N X21 4/15 135 2011 26 $75 1.5 F N R03 3/29 1995 27 $110 6.0 D Y G44 4/20 400 2015 </tbody> The...

I have the following macro Sub AddBlankRows() ' Dim iRow As Integer, iCol As Integer Dim oRng As Range Set oRng = Range("a1") iRow = oRng.Row iCol = oRng.Column Do ' If Cells(iRow + 1, iCol) <> Cells(iRow, iCol) Then Cells(iRow + 1, iCol).EntireRow.Insert shift:=xlDown iRow = iRow +...

Here is the code i found and adapted to my needs and works great. But I want to add an exception, to skip folders starting with ???? and move on to the next folder. Any assistance would be appreciated. So i want: For Each myfile, except. Sub ListMyFiles(MySourcePath, includesubfolders) Set...

Hi There, Happy new year to all! I'm trying to solve a problem that I have from a VAB code that I have found on the Internet. its about splitting one sheet into multiple sheets. Code runs fine but every time it gives me a extra sheet that I don't want like ("sheet69"). Is this problem ready...

Hi All I am very green to VBA so apologies for the massive gaps in my knowledge or if this has already been answered but I am struggling to find a code that covers what i would like to do. So i have to two workbooks, WB1 has a list of my projects (address and job database which contains the...

Hi guys, I have this macro that I found online: This code puts the remaining fields into a Pivot table, which is what I want it to do. The problem is that it is moving it to the Values field but I want the code to place the fields into the Row Labels. Does anyone know the solution to this...

Here is the macro I am using.. why am I getting sheets that show up with nothing instead of it just skipping to the next group. Private Sub CommandButton1_Click() 'Sub parse_data() Dim lr As Long Dim ws As Worksheet Dim vcol, i As Integer Dim icol As Long Dim myarr As Variant Dim title As...

I am trying to track down changes between 120 pairs of workbooks (that should be identical but someone changed some data). I have a list of filePaths for both workbooks. Plan is to open both, loop through each worksheet in both, load the used range of each worksheet into two arrays, compare...

Good morning, I am trying to track changes to a workbook in a worksheet named Audit I found a macro on this site and gave it a try but no changes are showing up in the audit worksheet. I inserted the macro in the workbook. I made multiple changes to the Quick Quote sheet and saved the...

Hi, I have created a macro to compare 2 data excel sheets, but I am trying to add a logic- 1st find key (column A in sheet1) in another sheet and if found compare all columns of that row and repeat the same till the last row and if there is any diff in column then post in summary sheet with key...

Hi There, I'm still quite new to VBA, so hoping someone could give me some advice. I have an excelsheet in which only certain columns are allowed to be modified by other users, thus I've protected these particular columns. However, I also want to be able to track any changes and I thought i'd...

Hi There, I'm still quite new to VBA, so hoping someone could give me some advice. I have an excelsheet in which only certain columns are allowed to be modified by other users, thus I've protected these particular columns. However, I also want to be able to track any changes and I thought i'd...

Hey Guys, I need help to doing following in VBA. In my Main worksheet, i will be having a template, that needs to be copied into 70 new tabs. Basically 70 Identical Sheets. However the differentiation between them is that, In Row 1 (A1,B1) each tab needs to show Unique Store + ID. Basically if...

Hi All, Been using this, but need for it to include contents within subfolders, and can't figure out how to do it. Any one suggest the way / provide a steer? Also, is it possible to add a column with details of the last user to save it, or access it? - not sure if that data is held with the...