Sort information from one sheet into another (same workbook)

**mmrojas** · 07-26-2012, 05:48 PM

I don’t know if I am posting this in the right spot, so please let me know. Here is my issue; I have a workbook with 2 separate sheets. First sheet is Summary, Second is Raw Data. I need the first sheet to pull and sort all the products from the second sheet and then I need it to sort this information into two columns. First column is for any product with a rating of 4.2999 and under and the second column is for all the products over 4.25. Is this possible? If this is possible, please tell me how. I appreciate any help I can get with this!

**arlu1201** · 07-28-2012, 03:28 AM

Do you have a sample file that you can upload?

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.