+ Reply to Thread
Results 1 to 1 of 1

Macro to create new worksheet with values from existing worksheet

  1. #1
    Registered User
    Join Date
    02-18-2011
    Location
    San Luis Obispo, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Macro to create new worksheet with values from existing worksheet

    Hello Experts!

    Basically:
    I am a VBA novice and have hit a roadblock. I need to create a macro to search through a column for records within a range of values. Then I need to copy the relevant rows and populate them in a new worksheet.


    Specifically:
    I need the macro (executed by clicking the orange rectangle in DataEntry) to search in the worksheet named QuarantineData for records that have both:
    • dates between today and two weeks ago (in column I)
    • null values (in column T)
    The corresponding rows of relevant data need to be copied and entered into a new worksheet. Ultimately, I would like to create a new worksheet each time this macro is run, named whatever today's date is. I know that there is a limit to the number of worksheets allowed but I can manage that later.

    Worst case: it's not possible to name a sheet after today's date, then I need to be able to delete all the old data and copy over the new records into the same worksheet each time the macro is run.

    I'm hoping some, if not all, of this is possible. If you need any further explanation or clarification, I'll be glad to explain. Any assistance you can offer would be greatly appreciated. Thank you for your time!
    Last edited by SamBam; 02-28-2011 at 05:10 PM.

+ Reply to Thread

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