PDA

View Full Version : VBA - Split/Extract data into specific worksheet with formatting



iamlearner
02-16-2019, 11:23 PM
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.