Microsoft Teams Blog articles

Link 2 sheets, then sort column A on sheet 2 alphabetically and match correct data

The user has two sheets within the same spreadsheet and desires to automatically import and update data from four specific columns of the first sheet onto the second sheet. The primary requirement is to sort the data from column B on the first sheet alphabetically on the second sheet. Corresponding data from the other three selected columns should be matched accurately to the resorted column B values. The user's initial sheet uses custom sorting by cell color, which is not desired for the data on the second sheet. The user is also encountering issues with blank cells, where formulas are automatically filling those cells with zeros or dates. The user is seeking a solution to avoid the undesired input of zeros and dates in blank cells on the second sheet. The user has included images showing attempted formulas and is looking for formulas to make this work. The user wants to avoid the original custom color sorting and have an alphabetical sort on sheet 2. The user is unsure if all the desired transformations are even possible. The user is concerned about protecting sensitive information. The user has spent considerable time searching for working formulas without success.
favicon
techcommunity.microsoft.com
techcommunity.microsoft.com