Update existing VBA code - Remove blank rows

Hi friends,

I got following example template with macro code which is doing following:

Once you click on button "Create LOI" in sheet "Analysis" you will able to choose worker and then new sheet(s) will be created by using appropriate data from Analysis.

As you can see, new sheets are created from default sheet called "LOI 4.0", where are input fields between rows 17 & 155.
My problem is, that if I run macro and newly created sheets are updated by appropriate data I have a huge number of blank lines till row 155.
Could you pls help me update following macro code which ensure that all rows without data in mentioned range will be deleted?

Please Login or Register  to view this content.

Thanks in advance for your help.

Originally Posted by walruseggman

Add this after Next r:

Please Login or Register  to view this content.

Thank you, friend. It works perfectly. So simple . Thanks so much!

Hi walruseggman, unfotunately I overlooked one bug yesterday. As I mentioned, if I updated macro as you advised it works, but not for all workers. I noticed these troubles if I run report for worker with name Dave. Refer to attached picture with results.
blank rows.jpg

Pls any idea what is wrong?

It looks, that it doesn't work if under one worker is more than 1 account group.

Sorry for confusion. Let me clarify my request.

Original code provided by me works correctly. It creates new sheets per account groups for chosen worker(s). It works with account groups available column "A" (there is white text color, so it is not visible). As you already know, new sheets are creating from default template LOI 4.0. Basically this sheet is copied and updated accordingly by appropriate data from Analysis. For now everything works correctly.

But I would like to update this code. I need to remove all blank lines in sheets created by this macro.

Code provided by you works perfectly only if there is one group for each worker. However if there are more groups for 1 worker (for example worker Dave from my example file) your code works only partially. Under Dave are listed two groups KU- accounts & CN- accounts. In one created sheet are lines removed, but for second sheet nothing changed and there remained blank rows.

Btw if you open example file there are more codes in Virtual basic. There is also Form. In simple explanation, all of these codes are assigned to button CREATE LOI. Unfortunately I am not so familiar with those codes and form and I supposed that updated should be only macro (Create_LOI_Sheets) provided by me at the beginning of this thread.