Consulting

Results 1 to 1 of 1

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

  1. #1

    VBA - Split/Extract data into worksheet based on selected cell value 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.
    Last edited by iamlearner; 02-17-2019 at 12:07 AM. Reason: Proper Title

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •