| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I read a date from another page
How do i read date in sheet1 (January), All January Dates from DATAsheet and all February in sheet2 (February), from DATA sheet Name Date Down Pay Etc John S. 1-Jan-04 5.00 Carla F. 2-Feb-04 7.00 Victor Z. 3-Jan-04 8.00 New Clients New Clients This Month This Month Sheet1 Sheet2 DATA Sheet January February Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I read a date from another page
Use an advanced filter in DATAsheet to copy the appropriate data to the
appropriate sheet. -- Regards, Tom Ogilvy IRMA MENDOSA wrote in message ... How do i read date in sheet1 (January), All January Dates from DATAsheet and all February in sheet2 (February), from DATA sheet Name Date Down Pay Etc John S. 1-Jan-04 5.00 Carla F. 2-Feb-04 7.00 Victor Z. 3-Jan-04 8.00 New Clients New Clients This Month This Month Sheet1 Sheet2 DATA Sheet January February Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I read a date from another page
Another possibility would be to use pivot tables in each of the destination
sheets. -- Regards, Tom Ogilvy IRMA MENDOSA wrote in message ... How do i read date in sheet1 (January), All January Dates from DATAsheet and all February in sheet2 (February), from DATA sheet Name Date Down Pay Etc John S. 1-Jan-04 5.00 Carla F. 2-Feb-04 7.00 Victor Z. 3-Jan-04 8.00 New Clients New Clients This Month This Month Sheet1 Sheet2 DATA Sheet January February Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to read this date format? | Excel Discussion (Misc queries) | |||
| how can i read the first row when i pull down the page?? | Excel Worksheet Functions | |||
| spreasheet too small to read in one page how can i fix this | Excel Worksheet Functions | |||
| Date to Text (please read) | Excel Discussion (Misc queries) | |||
| Office 2003 cannot read Excel page from my old computer. | Excel Discussion (Misc queries) | |||
Linear Mode
