Using a datafile to 'autofil' cells
Was wondering if there was a way to upload a external data file (csv) and get it populate cells.
IE - Could I load a list of 'Stakeholders' (make it a dropdown list) - and based on that selection from that dropdown list, it automatically fills in another cell, with lets say that 'Stakeholders Manager'
So basically 1 cell is automatically populated based on the 'Selection' of a dropdown value from another cell.
Anyone have any thoughts on how to accomplish this?