Forum Discussion
Trying to autopopulate data in one column based on data in different column
Hello, Data in column A is selected from a drop-down (data validation list). Data in column B is based on data in column A. For some entries in A there is only one choice (one-to-one) - I did this ...
That would require VBA, so it would work only in the desktop version of Excel for Windows and Mac.
If that is OK, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.