+ Reply to Thread
Results 1 to 2 of 2

Copy Data from one sheet to another

Hybrid View

  1. #1
    Registered User
    Join Date
    06-03-2012
    Location
    brighton
    MS-Off Ver
    Excel 2003
    Posts
    11

    Copy Data from one sheet to another

    Hi There, long time away from the forum.

    I want a macro that takes the data in blue (PM, Region, comments etc) in sheet1 and transfer it to sheet2 to the respective field (ie comments under comments)

    There maybe multiple data and do not want the data to ovewrwrite. So everytime the upload button is clicked it uploads the information from sheet 1 (the drop down menu (deactive) and the comments) and trsnfer the data to sheet2 I have a code that copies data in a row, but unable to manipulate it to pick up data that is not in a row as per this example.

    Can anyone help me? I have uploaded a workbook example

    Kind regards
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Copy Data from one sheet to another

    Sub Upload_Comments_Click()
    
    Set ws1 = Worksheets("Sheet1")
    Set ws2 = Worksheets("Sheet2")
    
    OpenRow = ws2.Cells(Rows.Count, "A").End(xlUp).Row + 1
    
    ws2.Cells(OpenRow, 1).Value = ws1.Cells(2, 4).Value
    ws2.Cells(OpenRow, 2).Value = ws1.Cells(3, 4).Value
    ws2.Cells(OpenRow, 3).Value = ws1.Cells(5, 4).Value
    ws2.Cells(OpenRow, 4).Value = ws1.Cells(7, 3).Value
    ws2.Cells(OpenRow, 5).Value = ws1.Cells(3, 6).Value
    ws2.Cells(OpenRow, 7).Value = ws1.Cells(3, 10).Value
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-05-2013, 07:03 AM
  2. Replies: 0
    Last Post: 05-21-2013, 03:09 PM
  3. Copy Data from a fixed form of data sheet into a master excel sheet.....
    By sirimhk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 08:48 AM
  4. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  5. Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data
    By santhoshjoseph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 07:07 AM

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