Results 1 to 2 of 2

moving information from one worksheet to another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    New Orleans
    MS-Off Ver
    Excel 2010, Excel 2007
    Posts
    12

    moving information from one worksheet to another worksheet

    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:
    1. find the 1st available row, (easy enough with lookup formula)
    2. copy the 1st cell (this where i get lost at)
    3. paste information into another worksheet
    4. 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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1