Forum Discussion
AutoFill Data (dependant on input, sourced from another sheet)
I have mediocre knowledge about Excel, and not sure if this is possible – any help would be greatly appreciated! I have 2 sheets in my xlsx file. Sheet one contains data about individuals, let’s ...
you could use VLOOKUP function and/or alternatively a combination of INDEX and MATCH Function, just to populate the necessary data of the picked individual
if you will update or change the data of the picked individual using your sheet 2, this requires some VBA in order to achieve this.
if you will update or change the data of the picked individual using your sheet 2, this requires some VBA in order to achieve this.