Thank you everyone for posting this code (http://www.vbaexpress.com/forum/show...el-spreadsheet) and alterations. It is very helpful. I have a word doc that has the user enter a keyword and a date, type information, then jump to the next page and repeat the process for a total of 10 times. Is there additional code to organize it so that each keyword and date appears on their own line in Excel rather than taking up 20 columns?
Thank you!