copy rows to worksheet two


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: copy rows to worksheet two

  1. #1
    Join Date
    Mar 2009
    Posts
    2

    copy rows to worksheet two

    need to copy columns A -G from worksheet one to worksheet two and delete rows which have a score number 4 in column D

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Welcome to DevX

    What do you have do far that isn't working for you?

    Will you be doing this in VB6 or Excel VBA?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Mar 2009
    Posts
    2

    copy rows to worksheet two

    i am working in excel. the first worksheet is an audit questionaire where they are scored 1-4

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    While recording a macro I did what you asked for, then put the code in command button, and it looks like it is working enough to get you started.
    Code:
    Private Sub CommandButton1_Click()
    Sub Macro1()
    '
    ' Macro1 Macro
    ' Macro recorded 3/27/2009 by Hack
    '
    
    '
        Range("B3:O15").Select
        Selection.Copy
        Sheets("Sheet2").Select
        Range("B2").Select
        ActiveSheet.Labels.Add(54.75, 23.25, 54.75, 16.5).Select
        ActiveSheet.Paste
    End Sub
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  5. #5
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,263
    Quote Originally Posted by phdwsm View Post
    need to copy columns A -G from worksheet one to worksheet two and delete rows which have a score number 4 in column D
    A few questions.

    Is Worksheet two a new or blank worksheet, or are you appending the copied data to the end, or are you relpacing everything on worksheet two with the data from worksheet one?

    Are columns (A - G) the entire worksheet or are you extracting just those 7 columns?

Similar Threads

  1. Replies: 5
    Last Post: 02-03-2010, 06:43 PM
  2. Loop to copy rows and paste into worksheet
    By damien_carr in forum VB Classic
    Replies: 0
    Last Post: 01-29-2009, 05:29 PM
  3. Duplicate Rows issue with SQL Bulk Copy
    By sdbul in forum Database
    Replies: 2
    Last Post: 10-02-2008, 03:07 PM
  4. copy and paste in listview
    By axeman in forum .NET
    Replies: 0
    Last Post: 01-20-2006, 04:25 AM
  5. Replies: 0
    Last Post: 03-14-2001, 03:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center