Adding conditions and variables to lengthy code

[scowalt]

Hey everyone! I'm fairly new to coding, especially in Excel, and I want to code a bit a grunt work so I wouldn't have to do it. Here are some example snippets of my code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

These macros are effective but, as you can see, terribly inefficient. They also have no variance for the length of the document etc. I tried coding these using a While statement, but it just didn't work out.

Can anybody help me improve my code? I would be very grateful!

[davesexcel]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Maybe supply a sample workbook showing what you want accomplished