rows above

Hello all, I need help with a macro to move rows/cells, similar to deleting a row and shifting everything up, but not, because there is important content outside of the table that should remain static. So, to clarify: The area I'm speaking of is from D4 to F15 only. Within this area, if...

Sometimes the easiest problem is hard to solve. I have a report that returns a dynamic number of rows depending on the volume of transactions. I already have code that takes me to the first blank cell in Col. "F": Range("A" & Rows.Count).End(xlUp).Offset(1, 5).Select Now i need to basically...

I have a worksheet that I need to add rows here and there in the worksheet. In a cell I'd like to have a link that runs a macro to add a row above that row. The issue is where this cell lives will obviously change and there will be more than one of these in the worksheet. So the code would...

Hello hello again, As stated above, I have a list of data that i filtered by color. After the filter has been done I want to sort through the leftover list of rows and add a row above each. As of right now this is what I have to find the rows, the next step being to add a row above each row...

Hello - I am having trouble with finding a value in cells in "A" (= "ethnic balance") and hiding rows in a certain range around the found value. Here is what I have started but cant get to work: Sub HideRows() Application.ScreenUpdating = False Dim i As Long Dim Lastrow As Long Dim hRow, uRow...

Hi. It is my first question here and I am sorry it is too trivial. I am constructing a formula with multiple criteria. =COUNTIFS(D21:D868, "INT OUT Employees", F21:F868, “>0.01”) But I have one more criterion. It is that I do not want to count a cell if the cell 4 rows above is not empty...

Hello, I have a list of about 300,000 company names with 1,000 of them being usable. The usable company names have content in column C. I essentially need to delete any row that does not have content in column C, but I need to keep five rows above and five rows below any company with criteria...