move range cell data up 1 row to fill in deleted data

I am using Rows 101 - 115 and columns A - C for UserForm data. I allow deleting 1 range of data at a time, that leaves my UserForm a empty row of data. After removing the data from,
example:

A102, B102, C102

I would like to move remaining data up to fill in the empty UserForm row.
example:

Row 103's data into Row 102
Row 104's data into Row 103
and so on to Row 115, all data starts in row 101, but not all rows contain data, example: row 101- row 104 have data and row 105 - row 115 are empty until more data is entered

I am using columns D - U, and row 116 for other information


I have tried

Please Login or Register  to view this content.

tried to explain in detail, and i continue to work problem
thanks in advance

was looking for a more graceful solution, but here it is;

took richards advice

1)looped through existing range, if it contained data then off to tmp location, erasing current data
2)looped through tmp location, copied now concurrent data to original location, erasing tmp data
3)refreshed UserForm data

Thanks,

yes Richard, I understand that, which is why I posted my problem - in an effort to elicit a more graceful and faster(code) solution. I do understand their are many VBA experts that would have approached the problem from a different angle, simply because of the knowledge possessed. The solution I came up with while not graceful, but it worked.

I post here not only to find help in solving code block but also to gain knowledge from different perspectives.

Respectfully, Have a good day.

I have a question I posted on the Excel Basics forum that sounds similar to this question. If its OK to piggyback here is what I posted (If not I will start a new thread, I just didnt want to add more threads if I didnt have to):

I am trying to make a digital bout board for a wrestling tournament. The matches have numbers assigned to them so that fans can track who is wrestling on each mat at any given time. I have seen tournaments use an excel sheet to display this before but have no idea how they did it because they had it set up so that when they entered a new match number on a mat it would automatically slide the other numbers to new cells.

The set up looks like this:
Column A | B | C | D | E
Mat # | Wrestling | On Deck | Warming Up | Bull Pen
1 | 1 | 4 | 7 | 10
2 | 2 | 5 | 8 | 11
3 | 3 | 6 | 9 | 12

I hope you can visualize that.

When Match 1 ends on Mat 1 match 13 would go to the Bull Pen section (Manually typed) and 1 then disappears while 4, 7, and 10 slide left.

Any ideas?