Hi Chief,
HTH
Open both wb's. In wb2 cell A1 +then switch to wb1 and click in A1. Copy
this formula to your range A1:G5000
ray

"chief" wrote:


i have wb1 and wb2. i want to link cells from wb1 - A1 to G5000, to wb2
same cells. what formula do i have to use?

thanks


--
chief
------------------------------------------------------------------------
chief's Profile: http://www.excelforum.com/member.php...fo&userid=7773
View this thread: http://www.excelforum.com/showthread...hreadid=390340