| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting rows to a another sheet
I have sheet 1 in a workbook with columns A thru D, rows 1 thru 5.
When column D in a row contains a value equal to or less than .77, I need that entire row (as A1:D1) to be copied to sheet 2. It would be great, but not required, if they were ordered by smallest value in D first, but I can't have any blank rows. I can do this very easily in Access with a query, but I need it in Excel. Can anyone help? Thanks Dataminer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
| Copying selected rows to another sheet | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
