Ask Me Help Desk - I am looking for a formula or a macro for excel.

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)

- Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)

- - I am looking for a formula or a macro for excel. (https://www.askmehelpdesk.com/showthread.php?t=517866)

I am looking for a formula or a macro for excel.

I am looking for a macro for excel. I have thousands of cells in one column to populate.
See below:
(Cell B4 - thousands of more rows.)
I have the following list, I need either a formula or a macro to fill the cell in column B when info is placed in column C. I need the info to follow the following list:
Doc 1
Doc 2
Doc 3
Doc 4

All times are GMT -7. The time now is 05:09 AM.