hi all, due to my limited knowledge and experience with loops i am hoping to get some help to further my abilities. i have 36 variables...some have values and some dont. this changes based on input. so for example, this time cpn1 may = " test ", but next time may = nothing. what i am looking to do is loop through variables cpn1 - cpn36 and if the variable has a value, copy that value to the last used cell in a column. its not much but i have this:
thank you for any input !!!!Please Login or Register to view this content.
Bookmarks