Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 28th 05, 10:29 PM
Helen McClaine
 
Posts: n/a
Default 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   Report Post  
Old March 28th 05, 11:03 PM
Carole O
 
Posts: n/a
Default

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   Report Post  
Old March 28th 05, 11:33 PM
Helen McClaine
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
How do I copy a cell (content AND format) from one worksheet to a. Excel Format Copy Excel Worksheet Functions 1 February 9th 05 10:34 PM
How do I copy data (word) into respective cells when the data bei. awg9tech New Users to Excel 1 January 12th 05 11:26 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017