my workbook has 2 worksheets in it. the 1st worksheet named "import" has 6 columns of phone numbers in it. But all of the columns are not filled with information. how would i perform a lookup, move and delete program?
the script would have to:
- find the 1st available row, (easy enough with lookup formula)
- copy the 1st cell (this where i get lost at)
- paste information into another worksheet
- delete information
i'm pretty sure i can find the information i want but i have no clue how to move or edit that information.
sample workbook is attached to this post
thanks in advance for your help.
Bookmarks