+ Reply to Thread
Results 1 to 1 of 1

Using advanced filter to create new sheets based on database

  1. #1
    Registered User
    Join Date

    Using advanced filter to create new sheets based on database

    Hey guys!! I have anothe question.....

    I have a sheet (attached) that Does ALMOST exactly what i want it to do.
    In simple, currenlty the sheet takes a column of data and makes a new sheet based on the data in the column. Then, on each instance of that value, it copies the ROW associated iwth it and places it on a newly created sheet. (see the attached sheet)
    There are problems with this
    #1) I can break it by having a Space or Null in a cell in column "C"
    #2) what if i dont want to create a sheet for EVERYONE that changes? I want to create a new sheet for only a select few people.

    What would be perfect is to have another sheet labeled "database" or somethign similar, and if the value in a cell int he database MATCHES the value in the Range (column C) that the macro searches, THEN it would complete the macro and create a new sheet and paste the row data.

    I know this is super confusing, please respond with questions.
    Attached Files Attached Files
    Last edited by eighty2scrambler; 02-17-2009 at 06:04 PM. Reason: Solved on anothe rforum

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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