ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   linking cells from different files -fill down (https://www.excelbanter.com/excel-discussion-misc-queries/51835-linking-cells-different-files-fill-down.html)

singlgl1

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


Ron de Bruin

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





All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com