Hi All:
I'm new to macro programming, so please excuse me if this issue is an easy one to resolve. I have a spreadsheet with a couple hundred ranges describing web postings. The original file was a text file, which I saved into Excel. Each range looks like this:
AUTHOR: Michael Smith
TITLE: “Blah Blah Blah"
STATUS: Draft
ALLOW COMMENTS: 0
CONVERT BREAKS: wysiwyg
ALLOW PINGS: 0
BASENAME: more-blah
CATEGORY: Partners & Affiliates
DATE: 11/11/2010 10:33:17 PM
-----
BODY:
<p>Christmas is upon us...<a href="http://www.failblog.org/</a>.</p>
I need to write a macro that will identify and paste the title, date, and link into columns on a different worksheet. Preferably, it would only be two columns, with the link hyperlinked in the title.
So far I've tried to record me copy and pasting stuff from the cells, but that proved to be a failure, as did any code I tried to write. Any help would be greatly appreciated.
Best,
Josh
Bookmarks