offset columns rows

Hi I'm having trouble with my offset I used my previous code and changed it so that it look for a specific word and search over multiple worksheets It does find the word and copies it over to the new sheet. but when it find the 2nd one it overwrites the previous line on the new sheet Thank you...

I want to copy columns A - I in a worksheet1 to another worksheet2 also in columns A-I. In my copy from worksheet1 I am finding the last row with referencing column B. The reason for doing that is because column A contains data from rows 2-5000, whereas columns B-I contains data in rows 2 -...

I am trying to analyse student marks over a period of 3 years, to determine value added by the school. I have 3 spreadsheets, for each of the 3 years. Unfortunately, the LMS the school is using has exported the data in 5 rows per student, showing their mark for each of terms 1-4, plus their...

Hi there, I have some code that is speeding up some checks that I do every week over 1000 rows etc. I am just after a little help in speeding up my checks as this is tedious work. What I am after is for a macro to check if the the previous column (i.e. Column R) has the same value in it and and...

I am trying to place an "x" in each cell for the corresponding hour based on the length of run. Then when a run is complete, I would like an "x" for the next scheduled item to show in the next available hour on the preceding row and so on up to 24 hours. How to I offset the next row to start...

lastRow44 = Cells(Rows.Count, "A").End(xlUp).Row Range("A" & LastRow3).End(xlDown).Offset(0, 11).Formula = "=Sum(M50:M" & lastRow44 & ")" I have vba code like this, but I want to modify it to replace M50:M to ("A" & LastRow3) to make code dynamic. However If I replace it, it does not work. Is...

Hello,need help with something simple but rather complex for me. i have a large list of 3 digit numbers in Column A. ex.(123)..I would like each digit separated in its own column (text to column) i would like these copied in a series of 3 with a space of 2 rows in between each series. Each...

Hi, I am struggling with my code below and I am hoping someone can help. I have a formula in column AP that returns a number or a blank. I am trying to write some code so that if my formula in column AP returns a number then offset/insert (X) number of rows below based on the value in column...

Sub Move_CenterANDDepart() Dim rng As Range, cell As Range, del As Range Set rng = Intersect(Range("C:C"), ActiveSheet.UsedRange) For Each cell In rng If (cell.Value) = "Valid" _ Then If del Is Nothing Then Set del = cell Else: Set del = Union(del, cell)...

I am trying to include an additional function in this formula: =SUMPRODUCT((Dom_Counts!$B$2:$CY$2<>"")*(Dom_Counts!$B$2:$CY$2=Dom_Counts!B3:CY3)) in order to increment the row numbers by 1 each time I drag it over to the next column without changing the column references. This formula is...

Hi All, I know there are hundreds of posts asking the same question but none of them seem to help me with my problem. I am a VBA newbie and I am trying to transfer data from one worksheet (ws1) to another (ws2)based on column headers. The headers are not in the same order in ws2 and there is...

Hi I would be grateful for some help, I have a data sheet with sales by month. Column A shows the monthly dates and columns B onwards show the monthly sales per store, I have a separate tab for each store and want to copy formulae down rows which increase/increment the column reference by two...