Please help this Newbie.....Copy entire row into a new sheet based on cell data

Does column B contain only numbers? It's hard to tell from your example if "AP" and "PA" are also in column B along with the number or if they are in column C. Could you post a copy of your file? It would be easier to see how your data is organized.

Correct Column B is only numerical using numbers 1-12. The AP and PA are in Column C. I have a total of 5 columns. The data is at work and I am at home currently or I would attach it for you to review. If I could just get a starting point that would allow me to email the info to work and then tinker with it. Sorry, I am not familiar with excel. I only use this one workbook and it is getting tedious having to do all the changes and copy and paste manually. Thanks for your reply.

Try this macro. You don't' have to enter the headers in the three destination sheets. The macro will copy over the headers from Sheet1. Run the macro each time there is an addition or change in Sheet1 and this will update the other three sheets.

Please Login or Register  to view this content.

Sorry ... somehow this duplicate post was created.

Try this macro. You don't' have to enter the headers in the three destination sheets. The macro will copy over the headers from Sheet1. Run the macro each time there is an addition or change in Sheet1 and this will update the other three sheets.

Please Login or Register  to view this content.

Could you post a copy of your file?

Originally Posted by Mumps1

Could you post a copy of your file?

I think I added the file correctly.

I have about 200 students which change frequently as well as the phone and addresses.

I sort them alphabetically in the (Master) using the column 1 (Student Name) and this sheet contains all students.
sheet 2 (CHS) should pull everyone from the Master in the grade column that has # 9-12 then place them alphabetically using Student Name
sheet 3 (PSMS)should pull everyone from the Master in the grade column that has # 5-8 then place them alphabetically using Student Name
sheet 4 (PVE)should pull everyone from the Master in the grade column that has a k or # 1-4 then place them alphabetically using Student Name

I have been entering all this manually for a few years and I need something to help me when I update the Master (sheet1).

I tried adding the macro in the code using the command button, it gave me an error. I am not sure that I know how to add the formula. I appreciate all the help you are giving me and the time you are spending on this.

Please help!?!?

Click here to download your file. Just click the button on your MASTER sheet any time there is an addition or change to the data in the MASTER.

In the sample file that I posted, the macro does what you requested. The data in your actual file may be organized differently affecting the end result. It is difficult to determine the problem without working with the actual file which is currently giving you problems. Is it possible for you to post the actual file, replacing confidential information with generic data in such a way that the data structure is not altered?