Results 1 to 3 of 3

Please help - Moving information from one sheet to another in the same workbook

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Please help - Moving information from one sheet to another in the same workbook

    Ok I am kind of a beginner to excel in the aspect of auto-populating/ moving information from one sheet to another automatically. I want to move information based on completion dates in column D on one sheet to another sheet, but I want to auto-populate rows of information based on this completion date, but not all information. I do not want information in column one in the first sheet to transfer to second sheet. So based on my completion date in sheet one, column D, Row 5, I want information from column B (sheet 1) to correlate to sheet 2, column B, starting in row 3, the assigned by in sheet 1 to relate to assigned by in sheet 2, the notes to do the same thing, and so on and so forth. Once the information is moved to the second sheet due to completion date, I want the information in the first sheet to delete itself. I know you can create a button for this, but am so unsure of where to start. Can anyone explain or help me in any way to get this done? I have been looking on the internet, but nothing seems to really explain or give me what I am looking for exactly. I have attached what I am working on so that you can see what I am trying to do. Its very self explanatory.Daily Task Sheet.xlsx
    Last edited by Malissa1578; 03-13-2013 at 01:01 PM.

Thread Information

Users Browsing this Thread

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

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