Is the formatting consistent from sheet to sheet?
ie. Are those "r" members always located in a merged C/D cell?
I'll post some code tomorrow night. I didn't bring my personal.xls home (its on my work computer), i forgot. So i'll stick with pseudo-code to start with.
Next thing is, i'm not too strong on formatting. I'm not sure how to handle all those merged cells. xlPasteAll might cope and put everything in the right place. Might need some assistance on that.
I'm also assuming you want those serial numbers in bold above the members. If not, then i'll have to rethink.
Lastly, are all these spreadsheets the same size? (400 rows-ish)
Bookmarks