I have a Workbook with several worksheets, each of which contain property data in a series of rows. Each row has a master 'Property ID' to link everything up.
I have created a separate 'master' worksheet with a drop-down showing all 'Property ID' values. When a user select a Property ID, I would like cells in this master worksheet to become populated with associated values from the separate worksheets.
Once populated, the user can make changes and hit a 'Save' button, which would then update the separate worksheets with the new values against the associated rows linked by 'Property ID'.
I have tried to do this myself, but can only aggregate all rows from worksheets (rather than single rows as defined by the 'Property ID').
Any help would be much appreciated! File attached
Bookmarks