+ Reply to Thread
Results 1 to 5 of 5

Trying to Move Data From One Sheet to Another If it Meets Criteria

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    New England, USA
    MS-Off Ver
    2010
    Posts
    5

    Trying to Move Data From One Sheet to Another If it Meets Criteria

    Question and info is attached.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,316

    Re: Trying to Move Data From One Sheet to Another If it Meets Criteria

    Hi, welcome to the forum

    Question and info is attached.
    No, you need to tell us what your question is, without the need to open a file
    Also, if this is an excel-related question, why would you upload a Word document, instead of an excel workbook?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-23-2015
    Location
    New England, USA
    MS-Off Ver
    2010
    Posts
    5

    Re: Trying to Move Data From One Sheet to Another If it Meets Criteria

    Excellent question. It's a word doc because i thought i could just copy and paste it on to the thread but the images do not show up so i had to attach it instead. My question is how can i move the header of a table in one sheet to the appropriate cell in another sheet that has a calendar on it if it meets the criteria. Criteria being a deadline in a certain month. I'm really quite terrible at explaining it without the help of images :/
    This is the just the text from the attached doc: I want to create a formula or macro (whichever is easiest) that will copy ‘Deadline 1’ or ‘Deadline 2’ into the appropriate column in another sheet that looks like: IMAGE OF THE TABLE There are already formulas in the first table that make it so once you enter the name and date the deadlines are automatically updated (say 30 days from the date). I would like the result to look like this: IMAGE OF THE TABLE Is this possible? Or should I just give up and manually move each deadline into the appropriate cells in the other sheet?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,316

    Re: Trying to Move Data From One Sheet to Another If it Meets Criteria

    Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

  5. #5
    Registered User
    Join Date
    09-23-2015
    Location
    New England, USA
    MS-Off Ver
    2010
    Posts
    5

    Re: Trying to Move Data From One Sheet to Another If it Meets Criteria

    Attached is the small sample thank you.
    Attached Files Attached Files

+ 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. Move data from one sheet to another by criteria
    By Pr0xy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2014, 02:24 AM
  2. Automatically Move Rows When one Column meets a Criteria
    By Apokolips in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2013, 09:55 PM
  3. Formula to move certain information in a column to a table that meets criteria?
    By MikeTruth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2012, 04:53 AM
  4. [SOLVED] PLEASE HELP - Macro needed to transfer data to another sheet if it meets a one criteria
    By Geller in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-10-2012, 12:22 PM
  5. Replies: 19
    Last Post: 04-21-2012, 07:21 PM
  6. move data to another sheet by criteria
    By albert28 in forum Excel General
    Replies: 1
    Last Post: 08-05-2011, 06:59 PM
  7. Move row data from one sheet that fits certain criteria to another sheet
    By sstewar1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2011, 06:16 PM
  8. [SOLVED] Array to read data from one sheet and write to another if it meets criteria
    By RudyShoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2006, 11:40 AM

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