Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut for same directory
I am trying to use a formula to copy info from three sheets into one sheet on
several different days. I will use this formula on different dates so I am looking for a shortcut to work in the date I input. hers the formula I have and I have to change it for each different day. Thanks =MAXA('C:\EXCEL\Tusc Files\Fuel sheets\Feb 10\Blank\[tsa.xls]Sheet1'!D13:H13,'C:\EXCEL\Tusc Files\Fuel sheets\Feb 10\2-5-2010\[FFa.xls]Sheet1'!D13:H13,'C:\EXCEL\Tusc Files\Fuel sheets\Feb 10\Blank\[GSa.xls]Daily fuel'!D13:H13) Ken Gray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to copy files names in a column from one directory to another directory VBA | Excel Programming | |||
Listing Active Directory groups that have directory access rights | Excel Programming | |||
Change current directory to the directory that the workbook loads from! | Excel Programming | |||
colour due to conditional formatting & hyperlink/shortcut to a directory | Excel Worksheet Functions | |||
Creating a macro that lists directory names within a directory.... | Excel Programming |