Results 1 to 8 of 8

VBA to copy a formula from a cell range and paste it to a cell range based on date

Threaded View

  1. 12-19-2019, 02:25 AM #1
    dedark05
    dedark05 is offline
    Forum Contributor
    Join Date
    03-22-2016
    Location
    Philippines
    MS-Off Ver
    MS Office 2013
    Posts
    124

    Question VBA to copy a formula from a cell range and paste it to a cell range based on date

    Hi All,

    I hope you can help me come up with a VBA code wherein it copies a formula from a cell range and paste it to a cell range based on current date that matches in column A where dates are located. The copy function should be similar to a default copy past in excel were it adopts when you drag down a certain formula. Thanks.

    Please see my file attached.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by dedark05; 12-19-2019 at 04:37 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy a cell range and paste it to a cell based on date
    By dedark05 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2019, 08:41 PM
  2. [SOLVED] VB Code to copy and paste range to certain sheet based on cell Value
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2019, 03:38 PM
  3. [SOLVED] Copy Paste a Range of Values from a Different Sheet Based on Value Entered in Cell
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-13-2015, 04:53 PM
  4. Copy and Paste a range based on a cell value that is not static
    By JmundleBofA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-10-2014, 03:25 PM
  5. Macro to copy and paste range based on cell value
    By msls09 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-05-2013, 12:57 AM
  6. VBA code to copy and paste range based on separate cell value
    By Mhofu in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-01-2012, 03:03 PM
  7. Excel IF a cell value is within a date range, copy row and paste in another sheet
    By Binaca04 in forum Excel General
    Replies: 8
    Last Post: 03-01-2012, 02:44 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1