Hi All, I'm creating a database from scanned copies of addresses. So far I have a LONG list of data that is luckily separated by the company name being in bold. I would like to run a macro that figures out that the record is from bold to bold (offset -1,0), so I can transpose it on a separate sheet in order to have each record on a separate row.

Does anyone have a suggestions on how I can select a range from bold to bold (offset by -1,0)?! Or any other suggestion? Another major list coming my way will be separated by an empty cell.

I would be super grateful if someone can help me out with this!
Thanks,
Liz