+ Reply to Thread
Results 1 to 7 of 7

VBA to copy from multiple sheets to a master sheet.

  1. 06-08-2022, 02:45 AM #1
    chris1979
    chris1979 is offline
    Registered User
    Join Date
    02-24-2016
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    20

    VBA to copy from multiple sheets to a master sheet.

    Hi
    Need you help

    My requirement is copy from multiple sheets and paste the data one after another in master sheet from a specific Cell

    Attached is the an example.
    Sheet Master - the data needs to be pasted from Cell C12 onwards
    Sheets1/Sheets2 - the data should be copied from A1 till the last row entered
    The cell borderlines should exist for all the rows in master sheet

    Regards
    CT
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-08-2022, 06:38 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,148

    Re: VBA to copy from multiple sheets to a master sheet.

    Posted file does not match your description.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 06-09-2022, 02:41 AM #3
    chris1979
    chris1979 is offline
    Registered User
    Join Date
    02-24-2016
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    20

    Re: VBA to copy from multiple sheets to a master sheet.

    Apologies

    Correct file attached

    Regards
    CT
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-09-2022, 06:59 AM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: VBA to copy from multiple sheets to a master sheet.

    Try this code
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  5. 06-09-2022, 10:18 PM #5
    chris1979
    chris1979 is offline
    Registered User
    Join Date
    02-24-2016
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    20

    Re: VBA to copy from multiple sheets to a master sheet.

    Thank you Srinivasa
    Works like magic

    However when I was testing the workbook, the macro threw a Application defined or object defined error. This happens when one of the worksheets didnt have any data, guess the vba needs to ignore the empty sheet and move to the next.
    Thank you for your assistance

    Regards
    CT
    Attached Images Attached Images
    Last edited by chris1979; 06-09-2022 at 10:22 PM. Reason: Attaching file
    Reply With QuoteRegister To Reply
  6. 06-10-2022, 02:58 AM #6
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: VBA to copy from multiple sheets to a master sheet.

    Try this code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 06-13-2022, 08:48 PM #7
    chris1979
    chris1979 is offline
    Registered User
    Join Date
    02-24-2016
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    20

    Re: VBA to copy from multiple sheets to a master sheet.

    Thank you Srinivasa. It works

    Regards
    CT
    Last edited by chris1979; 06-13-2022 at 08:49 PM. Reason: Adding more text
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need VBA Help: Copy same column from multiple sheets into master sheet
    By Jmiller73 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2021, 10:31 AM
  2. Copy data from master sheet to a multiple new sheets
    By pro1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2020, 04:30 PM
  3. Copy last column from multiple sheets to a master sheet
    By TallOne in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-11-2020, 03:37 PM
  4. Copy Same range from multiple Sheets to Master sheet
    By snatha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2019, 01:05 AM
  5. 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
  6. [SOLVED] Copy Data From Master Sheet to Multiple Sheets
    By dmmr in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-06-2013, 11:28 AM
  7. copy cell from multiple sheets to master sheet
    By ciprian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2011, 08:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1