Results 1 to 17 of 17

Copy 2 cells from each Row (into another Workbook) Based on Criteria of a third cell?

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    37

    Copy 2 cells from each Row (into another Workbook) Based on Criteria of a third cell?

    Tried to see if I could get something like this, yet to see anything though, and just wondering if you guys could help.
    Basically, I have a list of Patients, each with their own row and with 3 different Dispatch dates.

    (1) I basically need a macro (activated by Command Button?) which asks for the user to input a date.

    (2) It will then Look in Columns D , G and J For All Rows and look for that date, E.g. 25/10/13

    (3) Then if it is matching that date in either of those 3 columns, it will copy the cells in column A and B for that row (Branch and Name) into a New Workbook ( and preferably sort that final list by Branch - 100 going down to 500)

    (4) Also, at the same time, in that same Workbook I need it to make another 5 Worksheets( So 6 in total), each one designated for each Branch E.g. Patients in Branch 100 and being dispatched on Inputted date, will be on one sheet, Branch 200 and being dispatched on same date on next one, etc,etc.

    (5) And if possible, the top of each of those final worksheets should Have 2 Cells Saying "Name: " & "Delivery No.:" - This is for the person to write their details beside.

    Sorry for having something so long-winded :D greatly appreciate any help.
    Attached Files Attached Files
    Last edited by pharmerjoe7; 11-26-2013 at 01:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy two cells in on workbook to another workbook based on two criteria, but more
    By oldboots in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 06:17 AM
  2. Copy two cells in on workbook to another workbook based on two criteria, but more
    By oldboots in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2013, 05:44 AM
  3. Replies: 2
    Last Post: 07-25-2012, 08:11 AM
  4. Replies: 5
    Last Post: 06-08-2012, 11:26 PM
  5. Copy information from one cell to many cells based on certain criteria
    By thomasrawley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2006, 12:16 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