Hi all, in my project I need to put an underline beneath a letter as the database is updated.
I have got a working VBA using a loop which checks 20 rows in a particular column.
When a new database is imported, the letter in cell A61 is updated from a letter C to V
The vba then scans this 20 rows and if the cell is full will underline that particular letter.
Im sure there must be another way to streamline the VBA I have written and ask if anyone knows a better way of achieving the same outcome.
I have attached the file so you can see what I am attempting to do.
Bookmarks