|
Queries/Extracting
I've been going through past Qs without a solution
I have a spreadsheet with multiple columns and rows. I need multiple criteria to be met (all true) and then have the whole row extracted to a new worksheet, whilst ignoring blank entries. Below is an example of the .xls. Status Request Date M OR B Site PC 17" 19" 24" A4 OPEN 376929 11-Dec-07 M ORH OPEN 404577 1-Feb-07 M RIC 5 CLOSED 439579 22-Mar-07 M LMA CLOSED 448897 12-Apr-07 M ALB CLOSED 457180 27-Apr-07 M RIC OPEN 466290 14-May-07 B LMA OPEN 466291 14-May-07 B LMA CLOSED 466416 15-May-07 M ALB 3 3 1 CLOSED 469083 21-May-07 M RIC OPEN 469596 21-May-07 M ORH 1 1 OPEN 470477 22-May-07 M ALB 1 1 OPEN 470583 23-May-07 M RIC CLOSED 471075 23-May-07 M ORH |
Queries/Extracting
hi
is this a test where we have to guess what the multiple criteria is? regards FSt1 "Bec" wrote: I've been going through past Qs without a solution I have a spreadsheet with multiple columns and rows. I need multiple criteria to be met (all true) and then have the whole row extracted to a new worksheet, whilst ignoring blank entries. Below is an example of the .xls. Status Request Date M OR B Site PC 17" 19" 24" A4 OPEN 376929 11-Dec-07 M ORH OPEN 404577 1-Feb-07 M RIC 5 CLOSED 439579 22-Mar-07 M LMA CLOSED 448897 12-Apr-07 M ALB CLOSED 457180 27-Apr-07 M RIC OPEN 466290 14-May-07 B LMA OPEN 466291 14-May-07 B LMA CLOSED 466416 15-May-07 M ALB 3 3 1 CLOSED 469083 21-May-07 M RIC OPEN 469596 21-May-07 M ORH 1 1 OPEN 470477 22-May-07 M ALB 1 1 OPEN 470583 23-May-07 M RIC CLOSED 471075 23-May-07 M ORH |
Queries/Extracting
Two of my earlier responses have got lost, so I'll try again - use
autofilters so that you can set up your multiple criteria, then highlight the visible rows and copy/paste them to a new worksheet. Hope this helps. Pete "Bec" wrote in message ... I've been going through past Qs without a solution I have a spreadsheet with multiple columns and rows. I need multiple criteria to be met (all true) and then have the whole row extracted to a new worksheet, whilst ignoring blank entries. Below is an example of the .xls. Status Request Date M OR B Site PC 17" 19" 24" A4 OPEN 376929 11-Dec-07 M ORH OPEN 404577 1-Feb-07 M RIC 5 CLOSED 439579 22-Mar-07 M LMA CLOSED 448897 12-Apr-07 M ALB CLOSED 457180 27-Apr-07 M RIC OPEN 466290 14-May-07 B LMA OPEN 466291 14-May-07 B LMA CLOSED 466416 15-May-07 M ALB 3 3 1 CLOSED 469083 21-May-07 M RIC OPEN 469596 21-May-07 M ORH 1 1 OPEN 470477 22-May-07 M ALB 1 1 OPEN 470583 23-May-07 M RIC CLOSED 471075 23-May-07 M ORH |
Queries/Extracting
Yes it does in a way. I'm looking to try an automate as the I'm dealing with
over 20 columns and 300 rows. I'd like to set up something a bit more permanant that updates automatically by extracting new data as the spreadsheet is updated. A typical criteria would be open, by site, by m or b, by 17' Bec "Pete_UK" wrote: Two of my earlier responses have got lost, so I'll try again - use autofilters so that you can set up your multiple criteria, then highlight the visible rows and copy/paste them to a new worksheet. Hope this helps. Pete "Bec" wrote in message ... I've been going through past Qs without a solution I have a spreadsheet with multiple columns and rows. I need multiple criteria to be met (all true) and then have the whole row extracted to a new worksheet, whilst ignoring blank entries. Below is an example of the .xls. Status Request Date M OR B Site PC 17" 19" 24" A4 OPEN 376929 11-Dec-07 M ORH OPEN 404577 1-Feb-07 M RIC 5 CLOSED 439579 22-Mar-07 M LMA CLOSED 448897 12-Apr-07 M ALB CLOSED 457180 27-Apr-07 M RIC OPEN 466290 14-May-07 B LMA OPEN 466291 14-May-07 B LMA CLOSED 466416 15-May-07 M ALB 3 3 1 CLOSED 469083 21-May-07 M RIC OPEN 469596 21-May-07 M ORH 1 1 OPEN 470477 22-May-07 M ALB 1 1 OPEN 470583 23-May-07 M RIC CLOSED 471075 23-May-07 M ORH |
Queries/Extracting
Try to record a macro while you do this once, then you can play the
macro back each time you want to apply it. Pete On Jan 18, 2:08*am, Bec wrote: Yes it does in a way. *I'm looking to try an automate as the I'm dealing with over 20 columns and 300 rows. *I'd like to set up something a bit more permanant that updates automatically by extracting new data as the spreadsheet is updated. A typical criteria would be open, by site, by m or b, by 17' Bec "Pete_UK" wrote: Two of my earlier responses have got lost, so I'll try again - use autofilters so that you can set up your multiple criteria, then highlight the visible rows and copy/paste them to a new worksheet. Hope this helps. Pete "Bec" wrote in message ... I've been going through past Qs without a solution I have a spreadsheet with multiple columns and rows. I need multiple criteria to be met (all true) and then have the whole row extracted to a new worksheet, whilst ignoring blank entries. *Below is an example of the .xls. Status Request Date M OR B Site PC 17" 19" 24" A4 OPEN 376929 11-Dec-07 M ORH OPEN 404577 1-Feb-07 M RIC 5 CLOSED 439579 22-Mar-07 M LMA CLOSED 448897 12-Apr-07 M ALB CLOSED 457180 27-Apr-07 M RIC OPEN 466290 14-May-07 B LMA OPEN 466291 14-May-07 B LMA CLOSED 466416 15-May-07 M ALB 3 3 1 CLOSED 469083 21-May-07 M RIC OPEN 469596 21-May-07 M ORH 1 1 OPEN 470477 22-May-07 M ALB 1 1 OPEN 470583 23-May-07 M RIC CLOSED 471075 23-May-07 M ORH- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com