VBA to move data from master sheet to specific sheet

**cost15254** · 03-02-2014, 12:50 PM

Any help would be greatly appreciated.

Hello,

I am trying to build a workbook that will copy data from the master sheet (NBR) to the individual sheet (Agent Name). Every week I am going to place new data into the master sheet that is gathered from a web form my agents fill out. I would like the macro to run every time the workbook is opened and the NEW data to be placed at the top of the agents specific tab (essentally sorted by date, newest to oldest). I am fairly decent at writing logic formulas with calculations but when it comes to VBA I struggle. Thanks in advance for any help.

NBR4.xlsx

**davesexcel** · 03-02-2014, 02:12 PM

Check out the attatch example.

Click the button to run the code.

I have changed some of the sheet names to match the names under Agent column in "NBR" sheet as the names have to match in order for the code to find the correct sheet.

The NBR sheet and agent sheets do not match, this part of the code will have to change after so the correct info goes into the correct columns, right now the code will just copy A1:AA1 and put it into the first empty row of the agents sheet.

When you run the code as is you will notice some of ther sheets do not get data because the sheet names do not match the names under the agent column.

1-correct the sheet names so they match the agent names
2-determin what info you want into the agent sheets

The code can be edited later to sort each sheet.

This is the code used in the attached example.

Please Login or Register  to view this content.

**cost15254** · 03-02-2014, 03:37 PM

Thanks davesexcel,

I corrected all the sheet names and the macro runs good.

Now is there a way to only have just certain cells copied over and also is there a way to not duplicate the same data.