View Single Post
 
Old 07-31-2012, 09:55 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,713
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you adjust your data so that there are always 5 lines per record, as per the first 605 rows in the attached, the formulae on Sheet2 will do the job without the need for a macro. Simply copy the forumlae on Sheet2 down as far as you'll need (about another 250 rows).

If you look at Sheet 1, you'll see that '[1402121537] Leonard J Chabert Medical Center Program' has only 4 data rows. On Sheet2, the entry after that has 'VALUE#' in column A. Insert a line above '[1402122146] Ochsner Clinic Foundation Program' on Sheet1 and the Sheet2 output will be healed (the formulae in columns E & F adjust the output for 3 & 4 line addresses). Continue as necessary until all records on Sheet1 have 5 rows.
Attached Files
File Type: zip ACGME_IM_PROGRAM_LIST.zip (105.5 KB, 11 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote