Results 1 to 2 of 2

Copy range to specific column with specific date with macro

Threaded View

SEERC Copy range to specific column... 01-22-2015, 09:51 AM
SEERC Re: Copy range to specific... 01-29-2015, 03:09 AM
  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

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