+ Reply to Thread
Results 1 to 5 of 5

VBA for copy/paste specific cells from several sheets into a master data workbook

  1. #1
    Registered User
    Join Date
    10-17-2017
    Location
    Brasov, Roamania
    MS-Off Ver
    2013
    Posts
    4

    VBA for copy/paste specific cells from several sheets into a master data workbook

    Hello all,

    I am struggling to find a solution for a issue regarding a copy/paste VBA code.

    I am having two workbooks (workbook_1 with several sheets containing numbers and workbook_2 where I want to paste the values from workbook_1).
    From workbook_1 I want to copy specific cells (C12, F12, J12, M12, O12, R12 and T12) from each sheet and paste to workbook_2 in a down rows.
    I attached a sketch for a better understanding.

    Thank you in advance!
    Attached Images Attached Images

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: VBA for copy/paste specific cells from several sheets into a master data workbook

    You can run this from Workbook_2, Workbook_1 needs to be open.
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,275

    Re: VBA for copy/paste specific cells from several sheets into a master data workbook

    try this dont forget put this code in wb1 and dont forget open both workbook,and change your wb2.name
    Please Login or Register  to view this content.
    Last edited by daboho; 11-07-2018 at 08:15 AM.
    "ThankyouFor Attention * And Your Help!!"

  4. #4
    Registered User
    Join Date
    10-17-2017
    Location
    Brasov, Roamania
    MS-Off Ver
    2013
    Posts
    4

    Re: VBA for copy/paste specific cells from several sheets into a master data workbook

    It works nice and smoothly!

    Thank you very much for quick reply and for all your help!

    Best regards!

  5. #5
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,275

    Re: VBA for copy/paste specific cells from several sheets into a master data workbook

    dont forget mark case as solved

+ 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. [SOLVED] macro to copy in loop all sheets at specific row and paste in a new workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2018, 03:04 AM
  2. [SOLVED] Copy data from multiple files, then paste to master workbook.
    By TonyPepper in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2016, 06:35 AM
  3. Copy and paste different workbook data on master sheet
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2015, 12:03 PM
  4. Copy and Paste data automatically from master sheet to other sheets
    By wschleis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 04:29 PM
  5. Copy/Paste data from master workbook to multiple spreadsheet
    By lilbamboo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2013, 04:05 PM
  6. Copy/paste data from different work sheets to master sheet
    By Guckmall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2013, 08:23 AM
  7. [SOLVED] Copy specific cells from multiple workbooks and import them to a master workbook
    By Alby22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2012, 12:45 PM

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