Captain825
New Member
- Joined
- Oct 14, 2009
- Messages
- 40
Hi
New to Excel.
I need to select all the rows in sheet 1 where a cell is equal to or less than a certain value and then show all those rows in sheet 2. Can you please show me a simple way to do this?
Example:
Each row in sheet 1 has a cell that shows the number of days left before expiration of an event. The number of days in that cell is calculted with a formula. I want to select all the rows where the days left are less than 60 and then show all those rows in another sheet.
Thanks
Adrian
New to Excel.
I need to select all the rows in sheet 1 where a cell is equal to or less than a certain value and then show all those rows in sheet 2. Can you please show me a simple way to do this?
Example:
Each row in sheet 1 has a cell that shows the number of days left before expiration of an event. The number of days in that cell is calculted with a formula. I want to select all the rows where the days left are less than 60 and then show all those rows in another sheet.
Thanks
Adrian