I am wondering how I can take specific cells from a number of Excel Spreadsheets and put it into one master spreadsheet. On these individual spreadsheets, in some of the rows of data it has 'yes' in it or just 'blank'. These yes or blank values are also connected to number values ($2,089.00, etc.) and these values are what I want to be copied into a master file. I want to copy all of the number values that are ONLY connected to the cells that have 'yes' in it.
Cheers