+ Reply to Thread
Results 1 to 1 of 1

Copying data from two defined date ranges and pasting it on another sheet

  1. #1
    Registered User
    Join Date
    05-17-2019
    Location
    Berlin
    MS-Off Ver
    2004
    Posts
    1

    Copying data from two defined date ranges and pasting it on another sheet

    Hi All,
    I am struggling to create a code by which I can copy the data from defined date ranges(start date and End date) and pasting the data with respective dates in new sheet. I have two sheets with name

    1. sheets("Dashboard")
    2. sheets("Copied data").

    The sheets("Dashbaord") contains the buttons whereas the sheets("Copied data") contains data. My idea is to define a start date and end date in sheets("Dashboard"). The start date will be in cell J15 and End date will be in J16. The date column is present in the first column of sheets("Copied data"). By starting the code it should copy the date range (all dates between the defined date range) and respective data in column B and column C from sheets("Copied data") and paste it on another new sheet.

    The code is as below:
    Please Login or Register  to view this content.
    I ll appreciate any help in this regard!

    Thanks
    Last edited by 6StringJazzer; 05-17-2019 at 09:27 AM. Reason: Moderator added code tags

+ 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. Replies: 8
    Last Post: 02-01-2016, 09:30 AM
  2. [SOLVED] VBA to accept pasting current named ranges into defined ranges
    By phpolicylady in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2015, 01:33 PM
  3. VBA Macro Help: Copying and pasting data that is date specific
    By bleedUTorange in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-03-2011, 02:00 PM
  4. Replies: 2
    Last Post: 08-30-2011, 02:17 PM
  5. Do While Loop Q: Copying sheet data ranges to another sheet's ranges
    By foolios in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-30-2011, 05:05 PM
  6. copying and pasting data in separate sheet
    By ashwin_bist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2008, 09:36 AM
  7. Replies: 3
    Last Post: 07-24-2006, 08:20 PM

Tags for this Thread

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