Results 1 to 17 of 17

Copy data from one worksheet to another based on month/year

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2020
    Location
    Manchester
    MS-Off Ver
    Mac 2019
    Posts
    14

    Copy data from one worksheet to another based on month/year

    Hello,

    I have a sheet named 'caseload' where data is entered into columns A,B,C and D. Column D is the date the booking was completed. This data will be entered by different people as they complete the 'booking'

    I have further worksheets by Month/Year where further information is added and calculations undertaken.
    I currently just link the cells in caseload to January_2020.

    As each row of cells B,C,D and E of 'caseload' are completed, I want to copy the information in B, C and D to the relevant sheet based on month.

    So in my document, data in caseload B1/2/5, C1/2/5 and D1/2/5 would copy to January_2020 B1/2/3, C1/2/3 and D1/2/3 respectively as the booking dates (E1,2,5) took place in January 2020 and data in caseload B3/4, C3/4 and D3/4 would copy to February_2020 B1/2, C1/2 and D1/2 respectively as those booking dates (E3/4) took place in February 2020.

    I have tried LOOKUP and VLOOKUP with MONTH and DAY but failed and I don't have FILTER on my Mac Excel 2019...

    thank you.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by andynw1; 07-29-2020 at 03:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sum Data Based on a GL Code and Month in Year
    By tommpalmer123 in forum Excel Formulas & Functions
    Replies: 31
    Last Post: 04-28-2020, 04:33 AM
  2. Macro to copy rows and populate month/year based on start date?
    By ekwacillin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2016, 03:35 PM
  3. Month and Year in footer based on cell data
    By ERI GURU in forum Excel General
    Replies: 1
    Last Post: 03-06-2015, 02:10 PM
  4. Extract data based on month/year to a simple table.
    By maax555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2014, 09:55 AM
  5. [SOLVED] Macro to copy data from source workbook to target, based on current month of the year
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-27-2014, 05:41 PM
  6. [SOLVED] Copying data based on current month of the year
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2014, 06:33 PM
  7. Get Data based on Month and Year
    By karstens in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 07:50 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