+ Reply to Thread
Results 1 to 3 of 3

moving rows

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    Gibraltar
    MS-Off Ver
    Excel 2003
    Posts
    2

    moving rows

    Hi,

    I am working on a spreadsheet (call it "A"), with eight different columns. Four of which (the first four) will have feeded information from a seprate spreadsheet ("B"). The next four columns will contain information which will be inputted mannually.


    The problem i'm having, is that when I add a row to spreadsheet B, the information on the first four columns on spreadsheet A will move down accrodingly, but the mannual information I inserted in the last four columns, will stay in the same row they were inserted.

    How can I do it, so that when I add or delete a row in spreadsheet B, the mannual information on spreadsheet A, will move in sync with the first four columns? Hope this makes sense.

    Kr,

    Clint

  2. #2
    Registered User
    Join Date
    06-30-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: moving rows

    Hello Clint,

    I think is better to do it with VBA:

    PHP Code: 
    Sub Summary()
           
        
    Application.ScreenUpdating False
        
        Sheets
    ("A").Activate
            Cells
    .ClearContents
                Range
    ("A1:D1").Value = Array("COL1""COL2""COL3""COL4")
        
    Sheets("B").Select
            Range
    ("A2:D65000").Select
                Selection
    .copy
        Sheets
    ("A").Select
            Range
    ("A2").Select
                Selection
    .PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks _
                
    :=FalseTranspose:=False
        Application
    .ScreenUpdating True
        
    End Sub 
    Hope it helps

  3. #3
    Registered User
    Join Date
    06-26-2013
    Location
    Gibraltar
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: moving rows

    Thanks for your reply.

    Will try this out.

+ 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