+ Reply to Thread
Results 1 to 2 of 2

VBA - Split/Extract data into specific worksheet with formatting

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    89

    VBA - Split/Extract data into specific worksheet with formatting

    I have data (more than 60,000 records) in "Master" - A:Z. (Hidden)
    And I have an another sheet "Form_Entry". In Form_Entry sheet, cell E4 has drop-down (list of Master sheet column L unique values) of the Place list.

    When user selects the place from the drop down (E4), and clicks the Create Button there I want to run this macro, which split all data of the particular place into new sheet with the same formatting as in Master, with that place name (E4.value). If users tries to Create Button for already selected place then it won't allow to do so.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: VBA - Split/Extract data into specific worksheet with formatting

    Can you attach a copy of your file? De-sensitize the data if necessary.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. Extract Specific Data from one Worksheet to Another Automatically
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-03-2017, 09:55 AM
  2. Extract data from one sheet to another worksheet in a specific format
    By divi123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2014, 02:52 AM
  3. [SOLVED] Extract specific data from one sheet to another worksheet
    By divi123 in forum Excel Formulas & Functions
    Replies: 31
    Last Post: 03-31-2014, 08:15 AM
  4. [SOLVED] Extract Data in specific cells into a new worksheet using any method
    By ExcellingOS in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 08-05-2013, 04:35 PM
  5. Replies: 1
    Last Post: 02-22-2013, 12:20 PM
  6. extract specific data from a file into worksheet
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2010, 02:07 AM
  7. extract specific data from web to excel worksheet using button
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2009, 06:31 PM

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