Fetch data from a workbook and split into tabs

**Bilbash123** · 06-22-2015, 10:58 AM

I'm fairly new to VBA excel. I have an urgent query and any help would be hugely appreciated. I have a set template on which I create a command button, once we click the command button the macro should fetch data from a separate work sheet and split this 'fetched' data into separate tabs based on a specific column, lets say Rule and paste the data into my template into a specific range of cells.

Let me know if any more details are required.

Any inputs/help would be appreciated

**Pepe Le Mokko** · 06-22-2015, 12:05 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Bilbash123** · 06-22-2015, 12:56 PM

Thanks so much for the response. Attached are three excel files. The first one is the "Template and AFTER file" on which I want the macro built into (this is also the AFTER file which is the kind of output I'm looking for). The first tab, work plan overview will have a command button which will fetch data from the "Data to be fetched from" (file attached) file and split this into separate tabs based on the first column in the "Data to be fetched from" from (Control ID column) and the tab should be named as per the control ID.
The data should be pasted into the "template...." file from the cell A30 (scrolling down we can see the table).

Thanks so much for your help. Highly appreciate it.