Transferring CERTAIN Data from one worksheet to another
Hello,
This is what Im trying to do: I have 50+ worksheets within a single workbook. I am trying to gather specific data, by dates, and separate them by putting them into certain workbooks. That doesnt sound confusing at all, so Ill put in an example: I have 4 worksheets. Two are summary worksheets and two are input worksheets. In the input worksheet #1 I have: Date: Comments: 01/22/09 adflajd 02/24/09 ;lkfj;aoidg 03/09/09 ;alkdjfai 04/02/09 ioutiwetwe 04/30/09 v,cmvijoi 05/03/09 aietori In the input worksheet #2 I have: Date: Comments: 01/29/09 adflajd 02/02/09 ;lkfj;aoidg 03/14/09 ;alkdjfai 04/11/09 ioutiwetwe 04/23/09 v,cmvijoi 05/07/09 aietori In the first summary worksheet I want all information ranging from the dates: 01/01/09 to 03/31/09 and in the second summary worksheet I want all information ranging from the dates: 04/01/09 to 06/30/09. Thank a LOT! |
Transferring CERTAIN Data from one worksheet to another
Excel 2007
Consolidate selected columns of Tables in multiple sheets. Advanced Filter with Macro. No formulas. http://www.mediafire.com/file/yt3zykojend/05_07_09.xlsm |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com