rows count

I am working on a VBA code to do a couple things. The first is to add a new row and add the information I put into a seperate list. I want it to do this unless the Case Number and the Charge is the same. If those two things are the same then I want to fill in the rest of that row with that...

Hi, We are using the value "unique sku" to look up to. The problem is that each sale is on its own row and we need a total of all sales. I know what the answers should be, what is the formula? I am very stuck using SUMPRODUCT VLOOKUP. Does anyone even know how to do this please?! Thanks, RP...

Hello Excel Expert, Can anyone pls correct my code below, please. It supposed to read the rows count for each sheet then do something based on rows count value for that sheet but when I run the code below, it only read once only at the first sheet then use that same value towards all sheets in...

Hi, I've been successfully able to delete all excel tabs where there are 0 rows of data in it using the code below: Sub DelMT() Dim ws As Worksheet Application.DisplayAlerts = False For Each ws In ActiveWorkbook.Worksheets If Application.CountA(ws.Cells) = 0 Then ws.Delete Next ws...

Hi Ive got the Excel 2016 VBA and macros book and am learning lot but one huge frustration, the key line .... FinalRow = Cells(Rows.Count,1).End(x1Up).Row does not work for me. I get "Run-time error '1004': Application-defined or object-defined error". Is it something basic that I'm not...

Currently, I have a formula that only selects the first number found. What I want to do is add up all those matches. Please see info below. Here's the formula I currently use.... =IF(ISNUMBER(VLOOKUP($B1782,'Transfer Data'!$A$3:$G$22042,6,0)),VLOOKUP($B1782,'Transfer...

I have two sheets , one is for repaired car and another one is for returned car so I am trying to create an index formula that returns the returned car's brand name , Mechanic name and the problem but the information isn't accurate Note: there is only one car per brand name , which means if...

Hi everyone! I'm trying to count number of rows into files from some folders and sub folders. Folders and sub folders paths (C:\Users\Desktop\vba, ... etc.) are written in a G column. The result must be inserted in a column F. Maybe some one could explain, please, what is wrong with this loop...