Please Login or Register  to view this content.

Id like some assistance with a sort procedure. I have data entered into a seperate workbook from a userform. When that workbook or "Host" is opened, it needs to sort the imported data. However, each entry has a ref number entered from the userform. So from the userform, the ref number will always be entered but not all the userfom fields will be. when the above procedure runs, it overwrites previous with current. How do I make this to fill in the most recent info entered only if the previous ref number entry has no info or blank, or leave the current info if the newest entry is blank.

Also, how can i adjust the userform workbook so that if the end user has other and unrelated sheets open, the data always goes to the userform workbook and no others.

Thanks