Hello cheapkid1,
I believe this macro will work for you. It will start with the active cell. The macro will find the first non empty cell going down. It will then determine the current region for that cell. The current region is defined as a range of contiguous cells that are bordered around by at least one empty row or a side of the worksheet.
The macro does not reduce a multiple column regions to one only one column. So, the column the active cell is in will control the search for the next current region. The formula is copied starting from the second row in the region down to the last cell of the region until the last cell with a value in the column is reached.
Bookmarks