ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   easy way to Consolidate Data within one workbook's various workshe (https://www.excelbanter.com/excel-worksheet-functions/72646-easy-way-consolidate-data-within-one-workbooks-various-workshe.html)

estimator

easy way to Consolidate Data within one workbook's various workshe
 
Trying to copy data, that meets defined conditions, from one worksheet to
another worksheet within the same workbook in Excel 2003. Note: Please
simplify, I am not an advanced excel user. Thanks.

Debra Dalgleish

easy way to Consolidate Data within one workbook's various workshe
 
You can AutFilter the data, then copy and paste it. There are
instructions in Excel's Help, and he

http://www.contextures.com/xlautofilter01.html

Or use an Advanced Filtr to extract the data. There are instructions he

http://www.contextures.com/xladvfilter01.html

estimator wrote:
Trying to copy data, that meets defined conditions, from one worksheet to
another worksheet within the same workbook in Excel 2003. Note: Please
simplify, I am not an advanced excel user. Thanks.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 05:29 PM.

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