+ Reply to Thread
Results 1 to 5 of 5

Copy Specific Data From A Download Sheet To Other Sheets

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    Copy Specific Data From A Download Sheet To Other Sheets

    Hi everyone, been a while I was made redundant in 2015 after 41 years the majority of which was spent using Excel. I'm doing a bit of voluntary work for an Association and need a bit of help from the guru's on the forum.

    I'm using Office Pro 2010.

    The workbook has a Sheet called Download and 12 sheets named Jan, Feb, Mar etc. through to Dec.

    I need a macro that will do the following -

    Go to the download Sheet and select B6:H6 and to the bottom of the range which will change, at the moment it is row 53 so B6:H53 but next month that will might be H73.

    Sort the range newest to oldest based on Column B which has dates in it in this format 02/01/2019 for 2nd Jan 2019.

    Then using January as an example work down through Column B and copy columns B:H for any rows with a January date in Column B.

    Go to the Jan Sheet and paste into A6 keeping the source formatting. Repeat for every month of the year.

    I have attached a sample.

    As always many thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Copy Specific Data From A Download Sheet To Other Sheets

    Hi !

    I have an already easy way but working only if Excel tables rules are respected like in this case no empty column or row between data …

    So I let any other helper to play with your worksheet …

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Copy Specific Data From A Download Sheet To Other Sheets

    How about
    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    Re: Copy Specific Data From A Download Sheet To Other Sheets

    Many thanks Fluff13, that worked a treat!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Copy Specific Data From A Download Sheet To Other Sheets

    You're welcome & thanks for the feedback

+ 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. [SOLVED] macro to copy data range from sheet and past to specific other sheets
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-31-2017, 05:31 AM
  2. Replies: 11
    Last Post: 10-19-2016, 10:47 PM
  3. Replies: 0
    Last Post: 09-16-2015, 01:18 PM
  4. [SOLVED] Macro needed to copy data from master sheet to a number of specific sheets
    By krish2503 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-25-2015, 04:42 PM
  5. VBA to copy a template sheet to all other sheets except specific sheets to be excluded
    By chrisgreen83 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2015, 10:19 AM
  6. Replies: 0
    Last Post: 11-19-2009, 09:20 AM
  7. macro to copy specific data from one sheet and paste into two sheets
    By Shogun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2009, 04:56 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