Forum Discussion
Combining and sorting workbooks based on a single common column header.
Is there a way to combine and sort the columns from 2 workbooks so that in the example below, I could get the "Send Paper Bill" column tied to the rest of the account data in spreadsheet one regardle...
Daniel1945 - Why VLOOKUP is not a preferred choice here ?
- I was under the impression that Vlookup would only work if I was trying to pull data from a single column in the second workbook. While my original example did only contain one column of data that needed to be pulled, many of our workbooks will have more than one.
