Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy rows of data to another worksheet where ReturnDate is blank
I'm sure this is do-able within Excel but what formula I should use to
accomplish it escapes me. Basically, I'm working with a spreadsheet which lists books checked out from our Resource Center. When the books are returned, the Return Date is entered in column D. I want to run a report showing everyone who has outstanding books without having to go through the spreadsheet, row-by-row, to copy the data to the worksheet "Outstanding." Thanks for your help! |
#2
|
|||
|
|||
Try AutoFilter - Select Row 1, go to Data, Filter, AutoFilter. An arrow will
appear at each cell in that row. Click on the arrow in Column D. Ask for Blanks. Once you get the rows with blanks in Col D, you can copy and paste them into another spreadsheet. Hope this helps, Carole O "Helen McClaine" wrote: I'm sure this is do-able within Excel but what formula I should use to accomplish it escapes me. Basically, I'm working with a spreadsheet which lists books checked out from our Resource Center. When the books are returned, the Return Date is entered in column D. I want to run a report showing everyone who has outstanding books without having to go through the spreadsheet, row-by-row, to copy the data to the worksheet "Outstanding." Thanks for your help! |
#3
|
|||
|
|||
Carole -- Thanks so much. I knew it was something like that, but couldn't
remember how I'd accomplished a similar task in the past. Helen "Carole O" wrote: Try AutoFilter - Select Row 1, go to Data, Filter, AutoFilter. An arrow will appear at each cell in that row. Click on the arrow in Column D. Ask for Blanks. Once you get the rows with blanks in Col D, you can copy and paste them into another spreadsheet. Hope this helps, Carole O "Helen McClaine" wrote: I'm sure this is do-able within Excel but what formula I should use to accomplish it escapes me. Basically, I'm working with a spreadsheet which lists books checked out from our Resource Center. When the books are returned, the Return Date is entered in column D. I want to run a report showing everyone who has outstanding books without having to go through the spreadsheet, row-by-row, to copy the data to the worksheet "Outstanding." Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |