+ Reply to Thread
Results 1 to 3 of 3

look for today's date and paste special the value

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    8

    look for today's date and paste special the value

    Hello,

    I have a sheet that gets updated daily and I'm developing a macro to reduce the manual task.

    In column A i have the date and from column B to U are the data. I want a macro that will look for today's date and paste special the value for that day only.

    Please help!

    Thanks so much
    DD

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: look for today's date and paste special the value

    Quote Originally Posted by olympiaa2010 View Post
    Hello,

    I have a sheet that gets updated daily and I'm developing a macro to reduce the manual task.

    In column A i have the date and from column B to U are the data. I want a macro that will look for today's date and paste special the value for that day only.

    Please help!

    Thanks so much
    DD
    Can you elaborate on this; "paste special the value for that day only."

    What do you want to copy and where do you want to paste?
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: look for today's date and paste special the value

    Maybe:

    Please Login or Register  to view this content.

+ 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. LOOK UP, COPY PASTE into Another Sheet Within SAME Workbook - with TODAY Date
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2014, 06:22 PM
  2. Copy, Paste loop based on today's Date
    By oscarmiike in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-22-2014, 09:05 PM
  3. [SOLVED] Paste-Special Time & Date on Data Entry
    By MrCraig in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2013, 03:06 AM
  4. [SOLVED] Paste if column contains today's date
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2013, 11:52 AM
  5. paste special for date value
    By harishoy in forum Excel General
    Replies: 1
    Last Post: 09-30-2013, 08:42 AM
  6. Special Paste data using VBA to date specific column
    By JuliaBird in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2012, 09:24 PM
  7. Macro to copy/paste special based on date
    By lateforwork2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 07:26 PM
  8. Copy & Paste Special Values in Row Based on Date
    By mrfibbers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2012, 05:33 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