Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Name | 123 | ||||
2 | Name | 123 | ||||
3 | Name | |||||
4 | Name | 456 | ||||
5 | Name | 456 | ||||
6 | Name | |||||
7 | Name | 789 | ||||
8 | Name | 789 | ||||
9 | Name | 789 | ||||
Sheet6 |
Here is an example of what I have. I was going to auto filter to only display Blank cells in columb B. I then want a formula so that when I show all the cells again it will input whatever is above the blank cell. So using the example listed B3 would look up and grab the 123 from B2 and then input it into B3. How would I go about doing this?