Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from one worksheet to another | Excel Discussion (Misc queries) | |||
Transferring info from worksheet to report | Excel Discussion (Misc queries) | |||
Transferring chart data from one worksheet to another | Charts and Charting in Excel | |||
Transferring data from one worksheet or workbook to another | Excel Worksheet Functions | |||
Transferring data from one worksheet to another based on criteria | Excel Discussion (Misc queries) |