In Excel, return all values from separate sheet for columns with matching headers
I need to pull all values from columns with matching data headers from a sheet we'll call "Source" to a sheet we'll call "Destination", under the matching header.
For instance, there is a column with header "Address" in both sheets. In the Source sheet, that column contains URLs. I need a way to pull all of these URLs into the "Address" column in the Destination sheet.
I'm not sure if this will make a difference, but I need to do the same for quite a few columns in these sheets.
You could paste this formula in every cell on the Destination sheet that you want to pull a value for. You will need to change the forumla from $A:$Z and from $A$1:$Z$1 to something else depending on how many columns are in the source sheet: