Results 1 to 4 of 4

Add Project to 'database'

Threaded View

jieyi Add Project to 'database' 03-09-2009, 10:42 AM
rylo Re: Add Project to 'database' 03-09-2009, 10:02 PM
jieyi Re: Add Project to 'database' 03-14-2009, 11:52 PM
rylo Re: Add Project to 'database' 03-15-2009, 06:09 PM
  1. #1
    Registered User
    Join Date
    06-08-2008
    Posts
    36

    Add Project to 'database'

    Hi,

    I recorded my marco.

    Sub Add_to_Project_List()
    '
    ' Add_to_Project_List Macro
    '
        Dim R1 As Range
        
    '
        Range("C3").Select
        Selection.Copy
        Sheets("Project List").Select
    '   Range("A2").Select
    '    Range(Cells(2, 1).End(xlUp).Offset(1, 0)).Select
        ActiveSheet.Paste
        
        Sheets("Add Project").Select
        Range("C4").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("B2").Select
        ActiveSheet.Paste
        
        Sheets("Add Project").Select
        Range("C5").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("C2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C6").Select
     '   Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("D2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C14").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("E2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C8").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("F2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C9").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("G2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C10").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("H2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C11").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("I2").Select
        ActiveSheet.Paste
        Sheets("Add Project").Select
        Range("C12").Select
    '    Application.CutCopyMode = False
        Selection.Copy
        Sheets("Project List").Select
        Range("J2").Select
        ActiveSheet.Paste
    End Sub
    Basically my intention is to create a database filled with my projects.

    1) is there a way to simplify the coding?
    2) how to I add to a new line? This code always overwrite the first line.

    PS: It is recorded as a marco and i have not linked it to the button.
    Attached Files Attached Files
    Last edited by jieyi; 03-11-2009 at 11:57 AM.

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