Hi
Can someone assist with the required VB for this please?
In the example below, there are areas with subtotals but I need the Area description to be copied next to the sub total.
e.g. the string "Area A" needs to be copied from C2 to the next empty cell, C9. "Area B" needs to be copied from C10 to C17 etc, until all areas have been copied.
Thanks
Can someone assist with the required VB for this please?
In the example below, there are areas with subtotals but I need the Area description to be copied next to the sub total.
e.g. the string "Area A" needs to be copied from C2 to the next empty cell, C9. "Area B" needs to be copied from C10 to C17 etc, until all areas have been copied.
Thanks