Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking cells from different files -fill down
I'm trying to fill the same formula (links) down a column on a worksheet. I'm linking from the same cell from a months worth of files,only the file reference is changing as shown below.(11-1-05,11-2-05,etc..) Cell A1='C:\Reports\Nov\[11-1-05.xls]Production'!$Z$1 CellA2='C:\Reports\Nov\[11-2-05.xls]Production'!$Z$1 CellA3 ='C:\Reports\Nov\[11-3-05.xls]Production'!$Z$1 Thanks, Greg -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=478601 |
#2
|
|||
|
|||
linking cells from different files -fill down
Hi
Try this macro for this http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "singlgl1" wrote in message ... I'm trying to fill the same formula (links) down a column on a worksheet. I'm linking from the same cell from a months worth of files,only the file reference is changing as shown below.(11-1-05,11-2-05,etc..) Cell A1='C:\Reports\Nov\[11-1-05.xls]Production'!$Z$1 CellA2='C:\Reports\Nov\[11-2-05.xls]Production'!$Z$1 CellA3 ='C:\Reports\Nov\[11-3-05.xls]Production'!$Z$1 Thanks, Greg -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=478601 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
create a fill in template to tab to fill in cells | Excel Discussion (Misc queries) | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) | |||
Change a cell's fill color dynamically? | Excel Discussion (Misc queries) |