It is possible, because anything you can do manually with a keyboard or
mouse you can automate with VBA. The tricky part for you will be how
to tell Excel where to start a range and where to end a range. If your
column has blank rows in it already, you can get the macro to start at
the first non-blank cell, pick up the address, and step downward row by
row until a blank row is encountered, and write an appropriate formula
based on the current address. Do the rows have any other clues that
indicate where a range starts and stops? If yes, then your code can
use those as guidelines too.