ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy rows of data to another worksheet where ReturnDate is blank (https://www.excelbanter.com/excel-discussion-misc-queries/19503-copy-rows-data-another-worksheet-where-returndate-blank.html)

Helen McClaine March 28th 05 10:29 PM

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!



Carole O March 28th 05 11:03 PM

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!



Helen McClaine March 28th 05 11:33 PM

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!




All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com