+ Reply to Thread
Results 1 to 2 of 2

Copy range to specific column with specific date with macro

  1. #1
    Registered User
    Join Date
    01-22-2015
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    2

    Copy range to specific column with specific date with macro

    Hi all
    I have data in column a,b,c which get value from formula. Value in column b will change every day. Column c is today date. I must copy and paste special(value) from b3:b(n) to column d,e,f,,,,, according to specific date of d2,e2,f2,,,,,every day. (See the attachment). How to code macro to copy and paste special(value) from range b start at b3 to column d,e,f,,(start at row 3) according to specific date of d2,e2,f2 and when time >=17.00.

    Thanks for help.

    Seerc
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-22-2015
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    2

    Re: Copy range to specific column with specific date with macro

    sample sheet

    A B C D E F G H I
    Symbol Money In/Out Date 16-Jan 1/19/2015 1/20/2015 1/21/2015 1/22/2015 1/23/2015
    RICH -31,057,269 1/20/2015 14,040,642 -3,484,860 -31,057,269
    NDR -50,711,211 1/20/2015 101,752,373 138,339,831 -50,711,211
    MTLS 15,772,371 1/20/2015 3,439,954 -28,692,892 15,772,371
    KC -73,930,120 1/20/2015 -47,967,500 4,337,410 -73,930,120
    GENCO 110,461,292 1/20/2015 176,982,545 -37,918,495 110,461,292
    ECL 97,298,927 1/20/2015 49,344,612 140,448,850 97,298,927
    AKP 1,061,116 1/20/2015 59,424,961 -22,642,797 1,061,116

+ 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] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  2. [SOLVED] Copy a specific range to another sheet adding all the workdays for a specific time period
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-05-2014, 02:19 AM
  3. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  4. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  5. Copy data in Specific column in a specific range
    By macrofan2012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2012, 01:27 PM

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