Results 1 to 4 of 4

Link certain rows based on date to certain sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Link certain rows based on date to certain sheet

    HI,

    I would like to create a formula that links certain data to other sheets when date is passed certain value.

    All rows with date starting from 1 may 2013 should be in sheet april 2013
    All rows with date starting from 1 June 2013 should be in sheet may 2013
    All rows with date starting from 1 July 2013 should be in sheet June 2013
    All rows with date starting from 2014 should be in sheet 2014

    I also attached an example, I already copied the data in the correct sheets, but I would like to do it without copy pasting and use a formula

    Hope someone can help me,

    Much appreciated
    Attached Files Attached Files
    Last edited by keis386; 08-06-2013 at 11:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying rows to another sheet based on date range
    By LSAILLARD in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2017, 07:43 PM
  2. [SOLVED] Copy Rows To Predefined Sheet Based on Date Range Using Form or Message Box
    By Isacc in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-06-2013, 09:25 AM
  3. Moving rows of data to a new sheet based on date criteria
    By kaufmann98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 01:41 PM
  4. Copy rows to new sheet based on date range selected on a form
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2009, 11:40 AM
  5. Copy Rows In New Sheet Based On Date Range Criteria
    By ahmedwaseem2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2006, 05:45 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