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 same workbook. potential of duplicate billings or missed, each sheet (beside master) is a processed billing. Helllp please.
ie.
- 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.
