+ Reply to Thread
Results 1 to 4 of 4

move data from sheet1 to sheet2 based on date in column1 of sheet1

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Rochester, NY
    MS-Off Ver
    2010
    Posts
    4

    move data from sheet1 to sheet2 based on date in column1 of sheet1

    I would like to have some (or all) data from "Assignments" moved to individual "month" tabs. ie. if the date in column A is in October, then rows A-K would populate the "October" tab. Then I want to make updates on the "October" tab and have it update the corresponding items in the "Assignments" tab. (Vice versa would be okay too).
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: move data from sheet1 to sheet2 based on date in column1 of sheet1

    It sounds like what you want to do would create a circular reference within Excel. Without a workaround (such as two separate Assignments tabs, only one of which you update), or VBA, I don't think this can be accomplished.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,139

    Re: move data from sheet1 to sheet2 based on date in column1 of sheet1

    find the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    10-02-2014
    Location
    Rochester, NY
    MS-Off Ver
    2010
    Posts
    4

    Re: move data from sheet1 to sheet2 based on date in column1 of sheet1

    I've only had a chance to play with this a bit but it looks great. Didn't know the formula would have to be that complex. Thanks for all the work. If use the "assignments" tab for all the data input, I might have a 2-3 thousand rows over the next few years, with as many as 2-3 hundred per month. If I have 12 monthly tabs with 250 rows with your formula in each cell will that bog down the spreadsheet at all?

+ 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] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] Move data from SHEET1 to SHEET2 based on Selected criteria...like an adv filter
    By gspivey79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-03-2012, 02:06 PM
  4. Replies: 3
    Last Post: 06-06-2012, 05:36 AM
  5. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 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