I have some users that are manually entering data from one excel generated from a reporting system and entering in that data into hundreds of cells per day. The format of the report generated excel is static, so I want to map that data to the cells they are entering. The problem is the data is a moving target.

I want the formula (something like ='data'B2) to be entered into the first cell in the range if it is blank. When it is run the next time, if there is data in the first cell in the row, it needs to freeze that data/ remove the formula, and enter the formula in the next empty cell in that row. Any help would be appreciated!

It would look something like this pseudo code wise:

```
Range = a1-a9
If cell a1 blank then = Data sheet a1
If not blank then freeze cell data/ remove formula and enter formula = Data sheet a1
```

(and so on if necessary (unless better code))

until all cells in range are full