I'm running Windows XP Pro and MS Excel 2007. I have many spreadsheets that have nuggets of information. This problem will probably require the use of VBA. Would like to open a spreadsheet with data and a text file to copy to. Each spreadsheet has several hundred rows and about 120 columns of data. In column F of every spreadsheet I have integer numbers with 5 or 6 digits. In column CQ I have a comment in text. I would like to match the numbers in column F and whatever is programmed in VBA. If they agree, copy the date stamp to the text file, followed by a tab, then the contents of column F, another tab and then the contents of column CQ into the text file. I may have several rows to copy (several numbers from Column F).

I can open the spreadsheet using VBA but to make the comparisons, copy and paste them into something like notepad is somewhat daunting for me. Your assistance here would save me several days worth of work on several hundred spreadsheets, one spreadsheet for everyday in 2009. My ultimate goal would be to have a complete text file with all the numbers and their associated comments for each spreadsheet in 2009. Tab separation would allow me to copy and paste back into Excel for use in another application.