Overview:
I have a very large workbook filled with poorly organized data.
Goal:
1) I would like help creating a macro that would browse all sheets within the workbook (with various names) and search for two values within the sheet.
e.g. June 2010 and December 2010 (of any day)
2) In sheet one I would like inputed the exact value from the cell that contains June 2010 and December 2010 in all work books that have been searched.
e.g., in sheet "er1" macro has found cell with June 2010 and December 2010. It will then input the exact value of that cell in Sheet 1. 12th June 2010 and 31st December 2010
3) Lastly, using the cell found in the intial search macro I would like to use that as a reference and take the number which is 1 cell to the right and 2 cells down.
Would this be possible? I am totally lost in determining how to do this
Bookmarks