Hi Everyone!
Attached is a example of what im doing, the fields are populated by a VLOOKUP against another worksheet in the workbook.
Using the example attached you can see that if the vlookup doesnt have any data (so blank row in the other sheet) it displays all 0's when i paste special.
WHAT IM TRYING TO ACHIEVE:
Normally i would manually have to go into the spreadsheet and delete the rows that arent populated by data so in example this would be rows 208-216.
Is there a way with VBA to only create the Vlookup Boxes or 'Template' for the amount of rows that contain data in the other worksheet?
Thus no longer having to manually remove the lines and also not having to create more in the event that there is more than the number of 'boxes' i already have?
Thanks!
sample.jpg
Bookmarks