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?
Thanks in advance for your help.Please Login or Register to view this content.
Bookmarks