+ Reply to Thread
Results 1 to 5 of 5

Copy data to several guides per day with discretion

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Copy data to several guides per day with discretion

    Hello I have 31 tabs.

    I'd like to copy the data from A to F according to the criteria in column K, and if I have a number n column G and column K then the cells from A to F will be pasted on the sheet corresponding to that number.

    Thank's
    Attached Files Attached Files
    Last edited by marreco; 02-20-2012 at 07:35 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,663

    Re: Copy data to several guides per day with discretion

    I don't understand what the numbers in column K represent. They don't seem to have anything to do with the data pasted into the sheets indicated in column G.
    Ben Van Johnson

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Copy data to several guides per day with discretion

    I want to copy by date. but without the month and year only the day.

    If I have a day to copy a worksheet, if I have two days to copy to sheet 2 and so on!



    thanks for answering

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,663

    Re: Copy data to several guides per day with discretion

    The below macro copies the data to the sheets indicated in column G; it does not consider column K:
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Talking Re: Copy data to several guides per day with discretion

    You a great genius and helped me in a big way.

    Thank you very much!

+ 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