+ Reply to Thread
Results 1 to 1 of 1

copy & paste to other sheets depending on dates specified in cells

  1. #1
    Forum Contributor
    Join Date
    12-11-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    118

    copy & paste to other sheets depending on dates specified in cells

    Hello all,
    I am asking for help in a date related macro issue.
    I will be receiving a large amount of data on a daily basis soon, that I need to segregate into weekly sheets in the same workbook.
    My week will start every Monday, and end every Sunday.
    I would like to have a macro that will go to sheet "IMPORT" and pull data specified between the two dates in F3 and F4 and populate rows starting in A20:F20 to of every sheet.
    From column G:L, I will like to place the code to copy the formulas down, for the new data


    I have recorded macros for each sheet, and hard coded each sheets date into the macro, but I would like to have the code look up the dates in F3 and F4 in the "Activesheet", then go to the "IMPORT" sheet and copy the data from there, so I only need one macro, and not 52.

    I have tried to manipulate some codes I searched up, but I just can't seem to get it right.
    Your help is much appreciated
    Attached Files Attached Files
    Last edited by ufopilot; 02-02-2015 at 06:30 AM.

+ 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] Macro to copy and paste cells on multiple sheets based on dates
    By canyflyer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-21-2013, 06:24 PM
  2. Please Help with Copy/Paste and creating sheets depending on user input
    By rrstull in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2013, 05:43 AM
  3. Copy/Paste Cells and put into new sheets
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2011, 07:24 AM
  4. copy and paste cells with roll over dates
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2011, 01:43 PM
  5. Copy-Paste sheets - error in the dates
    By Aninha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2006, 12:10 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