Jun 24 2019 08:55 AM
I have a machine data log that I am manipulating to extract valuable data from. the column in question F, is partially filled with the data i need. Tab "Work", I need to fill the empty Orange cells with the value found in the green cell. the issue is that the green value in need changes with each log entry. I do not know how to create a logical statement of macro to fill the empty cell below the desired value until a different value is encountered, then use the new encountered value, so on and so forth. there are close to 95,000 lines with 30 different values I need populated through out the empty orange cell