Search results

I have a sloppy method now. basically I'm scooting over three cells in the same row when the previous three rows are blank. I start with checking if they are blank... Sheet1.Cells(z, c)="" then c+1 and c+2. If blank I copy c+3 to c, c+4 to c+1, and c+5 to c+3. Then I make where I copied from...

my data is "c" rows long, where c is a variable that determines the data row count. The data starts at line 3 and I need to copy the first three columns. So it's a rectangle starting at A3 and going to C(c+2). I know how to move rows from one sheet to another, but can't figure out how to call...

I have multiple rows with two types of information, type "A" and type "B" as noted in the first column. I am separating the types and organizing them on another sheet. My sorting uses the value of COUNTA(A:A)-1 (minus one for the header) to determine how far to go down the rows to separate by...

I have multiple rows with two types of information, type "A" and type "B" as noted in the first column. I am separating the types and organizing them on another sheet. My sorting uses the value of COUNTA(A:A)-1 (minus one for the header) to determine how far to go down the rows to separate by...