|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
08-07-2009, 02:23 AM
|
#1 (permalink) |
|
Registered User
Join Date: Aug 2009
Posts: 1
OS: XP Pro. sp3
|
Excel 2003 functions & vartables
I’m in over my head !!
On drive “C” I have folder sales In sales are yearly folders 2007, 2008, 2009 In the yearly folders are the monthly workbooks sales 01, sales 02 In the workbook the sheets are 1, 2, 3, for the day of the month i.e. c:\sales\2009\sales 08.xls In my sales recap workbook I wish at access daily item mean sales in the other Workbooks based on the Current date. I think something like this =”c”:\sales\YEAR(A1)’[sales MONTH(A1).xls]DAY(A1)’!$BL$33 Thanks for any help 
|
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
| Thread Tools | |
|
|
