Results 1 to 9 of 9

Selecting Data over a Date Range

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    32

    Selecting Data over a Date Range

    I have 2 worksheets where I need to transfer a certain amount of data from one to another depending on dates.
    Sheet ‘A’, is the main data source. Col A holds all 365 dates from 1 Jan to 31 Dec(starting at A2), and the subsequent data for each day is held in cols B to P.
    Sheet ‘B’ is the destination where the user will specify a key date in cell A3, then in A4 to A32, formulae populate the next 29 dates (ie so there is a continuous run of 30 days).
    What I need to do, is to identify the same 30 day range from sheet B on sheet A, then to copy the data in Cols B to P for that range back onto sheet B (pasting in at D3)
    Hope this is clear.
    Many Thanks.
    Last edited by Supdem; 09-15-2009 at 01:40 PM.

Thread Information

Users Browsing this Thread

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

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