sorting to different worksheets and editing based on master worksheet.

[jhyatt01]

I am what I would guess is at a beginner level of using excel. I am looking for help to have excel sort a master sheet into several worksheets based on several tabs. I will continue to be working on the master sheet and adding more data to it in the future, but as I add information I need it to change it on other sheets. So for example in the following pic, you can see there are projects with worksheets such as GC, 3000, JJ, 2000, BioRFI etc.. I need the entire rows to be sorted to different worksheets based on these projects, but as you can see, some individuals fall under 2 or more projects, and I need to be able to edit on the main worksheet. Also, if I add more individuals, I need those individuals to go to the worksheets as well.





can anyone help?

[arlu1201]

How would a png file help us? Attach a sample workbook instead. Dummy data will do as long as the format matches the original file.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[jhyatt01]

Anyone have any idea?

[arlu1201]

Column E to Column M hold the sheet names where the data should be copied?

Which columns from the master sheet should be copied to the other sheets?