I have a column that needs to filling in.
Row 1 may have a number
Rows 2-100 are empty but need row 1's data to be in it.
Then row 101 has something
but row 102-105 are empty.
basically I need to fill in the empty rows with data from a previous row.
( Selection.AutoFill )???
Row 1 may have a number
Rows 2-100 are empty but need row 1's data to be in it.
Then row 101 has something
but row 102-105 are empty.
basically I need to fill in the empty rows with data from a previous row.
( Selection.AutoFill )???