Hi,
Hopefully this will make sense! I'm looking for some vba code that look at all rows of data in a sheet, but loop within groups of that data.
For example in the below, I have some data with a value of 0 in ColumnC and what I want to do is to copy the value in the cell above to replace the 0, but that I want that to only happen within each particular group. E.g. I don't want the first record (record 10) in group 4 to be copied from record 09 of group 3 as it crosses groups.
ColumnA ColumnB ColumnC
Record 01 group 1 124
Record 02 group 1 0
Record 03 group 1 432
Record 04 group 2 123
Record 05 group 2 753
Record 06 group 2 0
Record 07 group 2 938
Record 08 group 3 563
Record 09 group 3 324
Record 10 group 4 0
Record 11 group 4 234
Any help would be great!
Thanks,
Bookmarks