+ Reply to Thread
Results 1 to 4 of 4

Macro to copy data from a master sheet to separate sheet as per date using a macro

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    16

    Macro to copy data from a master sheet to separate sheet as per date using a macro

    I know very basic macro/VBA.

    I need help in the attached excel with a macro which will help me copy data from a master sheet into separate sheets as per date in column A using a macro. The sheet name should be the dates and the data for that specific dates should be pulled into the sheet using a Macro.

    Can some one help me with a macro for this.

    Attached is the excel with my data.

    Thanks,
    Tejas
    Attached Files Attached Files

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

    Re: Macro to copy data from a master sheet to separate sheet as per date using a macro

    Try the following code in the example provided by clicking the button. You need the sheet names as the code filters the data using the sheet names.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Macro to copy data from a master sheet to separate sheet as per date using a macro

    Hi
    I found a piece of code that does exactly what you need. I have copied it into a module in the attached workbook sample.
    The code came from this link:
    http://www.extendoffice.com/document...on-column.html
    Hope it helps.
    Good luck.
    Tony

  4. #4
    Registered User
    Join Date
    06-23-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    16

    Re: Macro to copy data from a master sheet to separate sheet as per date using a macro

    Thanks a ton ARGK... you solved my puzzle in just a fraction of a second. It works exactly the way I want it.

    Thanks a ton ! God Bless !

+ 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. Copy sheet to another WB and macro copies that data to last row of master sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2013, 06:31 PM
  2. Macro to copy data from master sheet if match is found
    By shraddha5 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 02-08-2013, 02:17 AM
  3. [SOLVED] macro to auto copy data from multiple sheet to one master sheet
    By roger556 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2012, 01:52 AM
  4. macro to copy data in master sheet - issue
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 10-18-2012, 04:09 PM
  5. Macro to copy data from one sheet to a master sheet with running totals
    By gmi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2012, 10:53 AM

Tags for this Thread

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