extracting rows of data from a table that are met by criteria in two separate columns

**markhocek** · 03-12-2013, 02:49 AM

Hi all, I'm new to the forum and I am struggling to figure this one out.

I am trying to sort through an engineering data set (A:2,K:~15,000) and copy entire rows of data to separate sheets where two columns are the correct value that iI decide upon.

ie. I want to copy the entire row of data into a new sheet if ... in that row, column J = 96 and if column K = 18. I want these rows to go onto a separate sheet.
On top of all this I will want it to be redone for the same original data set except for a couple of different "J" and "K" combinations.

I would appreciate any help, I have found some code that I have managed to play with to get what I want, but this only sorts for the one column criteria, not both.

Thank you in advance !,

Mark

**arlu1201** · 03-12-2013, 03:20 AM

Please attach a sample file and also the list of conditions to be fulfilled -

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.

extracting rows of data from a table that are met by criteria in two separate columns

LinkBack

Thread Tools

Rate This Thread

Display

extracting rows of data from a table that are met by criteria in two separate columns

Re: extracting rows of data from a table that are met by criteria in two separate columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions