I'm not sure this will help. I'm fairly new to Excell & self taught. I
may not have understood your question completely. Anyway ... I
discovered this by accident when trying to repeat information from wb1
into wb2 automatically.

My formula originally read as follows:
=REPT('[workbook.xls]Sheet1'!$A$272,1) but it would only copy/paste on
wb2 exacly, instead of A272..A273..

I found that if you delete the $ in the formula on both sides of the A
- so now it looks like =REPT('[workbook.xls]Sheet1'!A272,1) - it will
still repeat the cell from wb1 to wb2.. and nowyou can copy the row in
wb2 and paste the formula to the remaining rows in wb2.

I have a haunting feeling that there may be some problem with this when
adding/deleting rows from one or both workbooks however. So youmay want
to get additional input... in fact, I will be looking for other replys
to your question.

Hope this helps.


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=468264