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

**BehrBrew** · 08-10-2013, 12:27 PM

Hello,

I have a workbook for collecting body composition information. Every month a group of 10-50 people with have their body composition analyzed and I would like to compile the results on to worksheets based on each name. When I run a new test some of the name could change and each person will have a differing number of previous test. I can no figure out how to set up a macro to search the the worksheet names and match to the value off the master sheet, then past the information from the master into the first open row. I would also like to figure out an msgbox/error box for if a name does not match a worksheet to either change the name or add a new sheet. I have attached the workbook with a few of my bad attempts at a macro. I am also open to suggestions if there is any easier way to organize this process. Any help would be greatly appreciated.

Thanks

Body Comp Template.xlsm

**jaslake** · 08-10-2013, 12:45 PM

Hi BehrBrew

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

**BehrBrew** · 08-10-2013, 01:26 PM

Jaslake,

Yes. That will be the most current data. The only history will be on the individual tabs. If it is easier to set up a running data page that contains the entire history, that would be okay. I would just need to set a page for the current results for the the group supervisor.

Thanks for your help.

**jaslake** · 08-11-2013, 11:32 AM

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.

**BehrBrew** · 08-11-2013, 11:55 AM

Jaslake,

That is amazing. Works better than I was even hoping. I'm sure it will take me a while to figure out how you did it but thanks you so much.

Thanks again

**jaslake** · 08-11-2013, 02:05 PM

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

**MaryCW** · 11-25-2013, 06:13 AM

My question is similar (I think). I have a file with names down column B in sheet 1 and want to transfer all cells C to AA in this row associated with specific names in this sheet to worksheet 2 which is set up with all the same headings. I can write a macro to copy the data but need to get the macro to look for the name in the cell in sheet 2 where I have the name I want the data transferred for. How do I get it to do this for each new cell I go to for which I want to extract the data from sheet 1 - can anyone help please?

**MaryCW** · 11-25-2013, 06:19 AM

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** · 11-25-2013, 06:19 AM

So I need the replace "Andrew Dibby" with the name in each cell I want the data for in sheet 2

**arlu1201** · 11-25-2013, 06:41 AM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Trying to copy and paste certain cells from one worksheet to another using a macro

[SOLVED] Macro - Copy and Combine values in cell and paste it in other cells based on Unique ID

Excel Macro to insert two rows based on condition and copy and paste multiple cells

Copy Paste cells into a new sheet based on criteria macro

Macro for WS/WB comparisons, and copy/paste two cells based on matches

Bookmarks

Bookmarks

Posting Permissions