Hi Ted,
From the look of your worksheet you need to determine the last cell in column B and then set your target range to be offset by 2 rows and -1 columns. You can use this with further offsets to put textbox contents in the appropriate locations.