Forum Discussion
Solved
VBA - Splitting worksheet by Dept
Hi This is a complicated task that requires a VBA expert. I have attached a file for you to review. What I would like is a VBA code to be able to take the data and split it into separate workshe...
I do not modified the program but just insert more comment for the changes. Hope you can learn it.
You have to understand the range and cells.
Range("J4") means the cell J4
Range("E" & r_CS &":H" & r_CS) represents the cells from column E to column H in the r_CS-th row.
On the other hand, we may consider cells as well.
Cells(1,2) means the cell in 1st row and 2nd column, i.e. the cell B1
You may also represent it as Cells(1,"B") in case you don't want to count the order of letters.
agrgar