Forum Discussion
Need to Locate data in workbook
Hello, spent hours on this over weeks and at a loss. list of 10k+acct #s and values ($) on a sheet, need formula to locate what other sheets/cells they are located. Seaching over 12 sheets in the s...
Do those other sheets have the same layout? If so, you could use Data,, From File to combine the information from all 12 sheets into one table.