+ Reply to Thread
Results 1 to 6 of 6

Need VBA code for copying datas from different sheets to one sheet

  1. #1
    Registered User
    Join Date
    05-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    41

    Need VBA code for copying datas from different sheets to one sheet

    Hello,

    On daily basis I used to prepare a report, for preparing this I will be getting 5 different excel files as input, to prepare this report I used to take two man hours.

    I thought of implementing macros in this report, but I am not sure how this will work, I will explain how I will prepare this report, please review and provide me the coding.

    I have attached a sample excel sheet, in this worksheet from sheet1 to sheet5 is the input file, now sheet1 is the base data, macro should calculate how many rows is available in sheet1 according to that each row with header column sheets need to be created and sheet names will be “po Number3” data. For this I have got the coding from Forum below is the coding.

    Please Login or Register  to view this content.
    Now will go to sheet KW8660, here column A to column O header column will be filled, now we need to fill column P to column W for this we need to take the data from Sheet2.

    In sheet 2 we need to filter the KW8660 and we need to copy the data from header and paste in sheet KW8660 (column P to W),
    Similarly from column X to A0 we need to take the filter data from sheet 3,
    then from column AP to BU we need to take the filter data from sheet 4,
    finally from column BV to CO we need to take the filter data from sheet 5.

    Like this we need to pull the details to all the sheets.

    For this I need a macro please help me…
    Attached Files Attached Files
    Last edited by kesavanprabhu; 06-25-2013 at 01:20 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need VBA code for copying datas from different sheets to one sheet

    Like so:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    05-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Need VBA code for copying datas from different sheets to one sheet

    Hello Jerry,

    The header details are same in all the sheets(From sheet KY9374 to sheet KZ1768), now finally with the header all the data need to be pulled in single sheet(From sheet KY9374 to sheet KZ1768).

    Please help me on this....
    Last edited by kesavanprabhu; 06-24-2013 at 10:49 AM.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need VBA code for copying datas from different sheets to one sheet

    Did post #2 sufficienty resolve the request as outlined in your original question?

  5. #5
    Registered User
    Join Date
    05-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Need VBA code for copying datas from different sheets to one sheet

    yes... If you help me in providing macro for post #3 will fullfill my complete request...

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need VBA code for copying datas from different sheets to one sheet

    I don't fully understand the new request and it seems completely new. Explain this new question in a new thread with a sufficient sample workbook of its own to demonstrate.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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