LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Conitional copying of a serie of rows from one spreadsheet to another

I have a large worksheet with data in it. I want to copy only those
rows that meet certain criteria to another worksheet. For instance - If
there is a certain value in column C and a date in column D falls
between a certain range I want to copy the data in the row to another
summary worksheet. I want to ignore the rows where the conditions are
not me so I don't have gaps in the summary.

Help greatfully received


David

 
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
excel spreadsheet is 4.77mb but only has 126 rows, why? Bazar25 Excel Discussion (Misc queries) 1 November 15th 05 07:01 PM
Can I make rows of an excell spreadsheet 'selectable' (on/off)? ralph r Excel Worksheet Functions 3 November 14th 05 04:20 PM
eliminating extra rows in spreadsheet roger-e Excel Discussion (Misc queries) 2 August 19th 05 07:33 PM
how do I unhide Excel 2003 spreadsheet rows with usual method. Sandy Excel Discussion (Misc queries) 2 July 13th 05 09:30 PM
Copying A Spreadsheet sparklydaisy Excel Discussion (Misc queries) 4 June 22nd 05 04:26 PM


All times are GMT +1. The time now is 07:24 PM.

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

About Us

"It's about Microsoft Excel"