Excel 2007 : Copy Data From One Sheet To Another By Condition

[ripssta30]

Good day to all, im a newbie When it comes to excel macro.. I was hoping if someone can help me with my problem.. i would gladly appreciate any help.

i have this workbook, a main worksheet named "SUM" contains all the data.. a blank column is labeled NAME which corresponds to the name of the sheets the data should be transferred.. the SUM sheet contains data from row 3 to 743.. so it is a lot. column C3:C743 is the column where the condition will be input. the other sheets are named, KAT, MIKE and JAMES.. for example, if u input JAMES in C3, the whole row 3 will be copied to row 3,sheet JAMES. if you change the data of C3 from JAMES to MIKE then the data will be transferred from sheet JAMES to sheet MIKE. the data from JAMES should be deleted because of the change. is this possible? thank you so much for your help. more power!

[ripssta30]

up for this page.. i attached a sample workbook now.. thanks!

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I will say that you don't need amacro at all, simply a better designed spreadsheet

[ripssta30]

I will say that you don't need amacro at all, simply a better designed spreadsheet

Sorry for not following the rules.. Ive changed it to comply to the problem.

Anyways, ill be dealing with rows as much as 1000.. and i need to distribute the data to each sheet for monitoring.. It would really help if you can help me make a VBA script for this concept.. again i apologize for the violation.. and thanks for the reply.. more power to you sir.

[royUK]

Thanks for taking the time to read and comply with the rule .

There's some code in this earlier post that can be adapted for your needs

[ripssta30]

thank you for your time sir Roy.. but again i have no knowledge in macro whatsoever.. so have no idea where to place the column range, sheet names and the other stuff.. sorry if im being such a pain in the butt.. please help

[royUK]

The purpose of the Forum is to help members gain knowledge of Excel, this requires some effort on your part, i.e. some attempt at understanding & implementing the code. If you don't want to learn then maybe you need to employ a consultant to do the work