Help with Macro to Copy/Paste cells to different worksheet based on Value

Hi BehrBrew

Will the Data in Master ALWAYS be new Data (Data that's not been previously transfered)?

Hi BehrBrew

I've added two Modules to your Sample Workbook and an additional Worksheet named "Template".

In order for the Code in Module Transfer to function properly the Formulas in the Individual Player sheets in Range("B3:F33") need to be cleared. This Code does that

Please Login or Register  to view this content.

The Code in Module Transfer is the Code that distributes the Master Records to the Individual Player sheets. The Code will add a new Worksheet for any new Player if the Individual Player sheet does not already exist. You'll receive a message that the New Player Sheet has been added. This Code runs from a Button on Master sheet.

Please Login or Register  to view this content.

I've not monkeyed with Cells B34 to G39 in the Individual Player Sheets...only you know what these are to do. Of course, try the Code n the Sample file and/or a COPY of your live file. Let me know of issues.

You're welcome...glad I could help.

I ran this macro for one name but need to do it for different names - so I need to get the macro to use the name I run in the cell I'm in when I run it:

Please Login or Register  to view this content.

MaryCW,

Welcome to the forum.

2 pointers - 1. I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

2. Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.