Results 1 to 4 of 4

Macro to copy data from one sheet, paste in another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Manila, Philippines
    MS-Off Ver
    2007
    Posts
    2

    Macro to copy data from one sheet, paste in another sheet

    Hi guys!

    New to the thread and this forum is great as I'm really interested in learning how to create macros.
    I would like to ask for help. I need to copy a certain group of cells from one sheet to another, and then do it for x number of times. I'm just using the record function and now i'm lost. Here is the code i currently have:

    Sheets("Mapping QTR2").Select
    Range("B137:D230").Select
    Selection.Copy
    Sheets("ExpDB_Q1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Selection.End(xlDown).Select
    Range("A99").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    End Sub

    also, column C is blank. i would like to get the values from another list in the same workbook, say "branch list". I would like to populate Column C with one specific branch for each "batch", if that makes any sense...

    hope you guys can help...

    thanks a lot
    Last edited by papi-O; 07-29-2014 at 04:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste data from different sheet - No Macro Please
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 10:45 AM
  2. Macro to Copy data from one sheet and paste to another sheet based on a condition
    By SaurabhShri1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 09:30 AM
  3. [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
  4. Copy Sheet / Create & Name New Sheet / Insert Before a Sheet / Paste Data
    By thinkspac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 02:27 PM
  5. Macro to search the sheet name and copy and paste the data from a major sheet
    By salma2009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2009, 02:11 AM

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