+ Reply to Thread
Results 1 to 6 of 6

Copy form multiple sheets to one master

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    greece
    MS-Off Ver
    Excel 2010
    Posts
    66

    Copy form multiple sheets to one master

    Hello i need again your help.

    I have 12 sheets in a workbook. Also i have a result sheet.

    I need to copy from each sheet the column B3:B to the result sheet.

    Every column from every sheet i need to be placed one next to the other at the result sheet.

    Please any help!!!!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy form multiple sheets to one master

    Is there data already in the result sheet?

    If yes, should it be deleted before copying data from the 12 sheets?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    greece
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Copy form multiple sheets to one master

    Yes there will be data and should be delete it.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy form multiple sheets to one master

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-22-2013
    Location
    greece
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Copy form multiple sheets to one master

    Yes it is working as i want.
    Thanks a lot.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy form multiple sheets to one master

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


    9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

+ 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. Insert and Copy to Multiple Sheets from a Master Sheet
    By mja05d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2013, 11:52 AM
  2. Copy Data form other Sheets to Master if marked as Active
    By A_TSC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2013, 02:44 PM
  3. VBA /macro to have a master form for multiple sheets
    By nemo0904 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-15-2013, 03:47 PM
  4. [SOLVED] Copy Data to Master List from Multiple Sheets
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 12:59 PM
  5. Copy & rename sheets across multiple workbooks into one master.
    By CapnSef in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-25-2012, 03:58 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