Hi all!
I have an Excel sheet where I want to flow down information based on a cell value.
My Excel spreadsheet contains a list of project numbers in two levels (always the base level which contains project information, and level 1 which doesn't contain that information). The list I have is a download from a project management system, but this download is incomplete with regards to the level 1 info.
<tbody>
</tbody>Could VBA be used to flow down this information based on the first 6 characters of the project number?
I have an Excel sheet where I want to flow down information based on a cell value.
My Excel spreadsheet contains a list of project numbers in two levels (always the base level which contains project information, and level 1 which doesn't contain that information). The list I have is a download from a project management system, but this download is incomplete with regards to the level 1 info.
Project Number | Business Unit |
02BK83 | P&C Americas |
02BK83.01 | |
02BK83.NB |
<tbody>
</tbody>