Hi,, I have a large spreadsheet, that I'm looking to extract some info from, into another sheet in the same workbook... Basically waht I want to do is move info from sheet 'sec8' to 'parsed'.
I would like it to lookup in column B to find "TOTAL FOR HOUSING AUTH:"
Extract that plus 2 digits which are always in the same place, so some type of offset, if I do a Ctrl + Up, then down 2 rows, right one column, and the first 2 digits in that cell.
Then also extract the info in the next 3 columns C-E, which are dollar values next to the "TOTAL FOR HOUSING AUTH:"
In the end I want the new sheet 'parsed' to be like this
-----------columnA B- C D
TOTAL FOR HOUSING AUTH: 02 $xxx $xxx $xxx
TOTAL FOR HOUSING AUTH: 09 $xxx $xxx $xxx
Any help is very much appreciated!!!