+ Reply to Thread
Results 1 to 4 of 4

Copy and Pasting into next available row

  1. #1
    Registered User
    Join Date
    07-09-2010
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copy and Pasting into next available row

    I have two sheets that I'm working with. The first sheet is an entry sheet where a part number and quantity are entered. The second sheet keeps a list of what is entered on the first sheet. Basically I want to cut the part number and quantity from sheet one, paste those values into sheet two, and then clear the info entered on sheet one. Then, when the next part number and quantity are entered into sheet one, I want that information cut and pasted directly under the previous information in sheet two. And then keep repeating. Any ideas on how to accomplish this with one macro? Thanks.

  2. #2
    Registered User
    Join Date
    06-11-2010
    Location
    grinnell, iowa
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: Copy and Pasting into next available row

    Can't tell exactly what you want done without more details/example worksheet, but this bit of code should be helpful for your purposes if you can figure it out and adapt it (pay attention especially to (rows.count, 1).end(xlup).offset(1,0), because that's how you get data into the next available row):
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Copy and Pasting into next available row

    No workbook, eh?
    Oh well, your macro will need lines such as:
    Please Login or Register  to view this content.
    Then:
    Please Login or Register  to view this content.
    Then to copy and paste, maybe:
    Please Login or Register  to view this content.
    etc...
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    07-09-2010
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copy and Pasting into next available row

    Thanks for the help guys. Sorry for not attaching a workbook. I'm really in the planning stages. I'll try this out and post what I am able to get.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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