+ Reply to Thread
Results 1 to 7 of 7

Copying data from multiple sheets to one sheet

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Copying data from multiple sheets to one sheet

    Hi Team,,

    I have 2 excel worksheets in a workbook and i want the data of both the sheets copied in a new sheet called summary sheet.

    I have 3 columns in all the 2 sheets i.e. Emp SNo,Emp Name & Emp Id.
    the column no's are B,C & D and the range starts from B3.

    The data should get deleted from the summary sheet and then new data should get uploaded

    Need VBA code for the same with steps as i am a Layman.

    Regards,
    Aparna

  2. #2
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Copying data from multiple sheets to one sheet

    try this.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Re: Copying data from multiple sheets to one sheet

    Hi,

    It works perfectly.Thanks a bunch but only headers are repeating twice.

    Can u pls let me know how to restrict the headers to only one time.

    Regards,
    Aparna

  4. #4
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Copying data from multiple sheets to one sheet

    May be!

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Re: Copying data from multiple sheets to one sheet

    EmpNo EmpName EmpId
    1 Adarsh 100
    2 Priya 200
    3 Sapna 220
    4 Diya 250
    5 Gagan 280
    EmpNo EmpName EmpId
    1 Rohit 120
    2 Harsh 150
    3 Aayush 320
    4 Litika 350
    5 Raman 400
    Hi The ouput is coming this way.Repetition of headers twice from 2 sheets.
    Pls help

    Regards,
    Aparna

  6. #6
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Copying data from multiple sheets to one sheet

    Hi Aparna,

    Its working fine from my end.Please check attached.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Re: Copying data from multiple sheets to one sheet

    Thanks a Lot.I was saved

    Thanks once again

    Regards
    Aps

+ 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. Copying data from multiple work sheets to a master sheet
    By cpgeorgejohn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-29-2012, 09:37 AM
  2. Retrieving data from multiple sheets and copying to a new sheet
    By Yahoho in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-30-2012, 10:15 AM
  3. Replies: 0
    Last Post: 03-27-2012, 04:54 PM
  4. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM
  5. Copying data from multiple sheets to master sheet
    By phong919 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2010, 04:30 PM
  6. Copying row data from a Master sheet to multiple sheets
    By f3racer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2009, 08:28 PM
  7. Searching for data across multiple sheets and copying to one main sheet
    By truedonk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2008, 08:13 AM
  8. Copying data from multiple sheets into one sheet
    By Todd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2005, 11:05 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