formula with moving range
 

I have a workbook that updates daily. When it updates the new updated
value goes in the top row of the column lets say A3 and moves the rest
of the values in the column down one row. I want to link these values
to another workbook named Games2. What formula can I use to copy these
values? example The first day it copies A3:A212 the next day A3:A213.
Can anyone help?


--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=484163

formula with moving range
 

Hi,

Let's suppose that the orginal data are in Sheet1 in the workbook named
xxx.xls.
Use the following formula in A3 of the new workbook (modify the workbook
name and worksheet name appropriately)

=IF([xxx.xls]Sheet1!A3="","",[xxx.xls]Sheet1!A3)

and fill-in the formula down to a large number of rows (say A3 to A1002)

Regards,
B. R. Ramachandran

"sctroy" wrote:


I have a workbook that updates daily. When it updates the new updated
value goes in the top row of the column lets say A3 and moves the rest
of the values in the column down one row. I want to link these values
to another workbook named Games2. What formula can I use to copy these
values? example The first day it copies A3:A212 the next day A3:A213.
Can anyone help?


--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=484163

formula with moving range
 

Change Destination range from D10 below to where you want it to go..

Range("$A$3").select 'In Sheet1
Range("$A$3", Selection.End(xlDown)).Copy _
Destination:= Sheets("Sheet2").Range("D10")

HTH

"sctroy" wrote in
message ...

I have a workbook that updates daily. When it updates the new updated
value goes in the top row of the column lets say A3 and moves the rest
of the values in the column down one row. I want to link these values
to another workbook named Games2. What formula can I use to copy these
values? example The first day it copies A3:A212 the next day A3:A213.
Can anyone help?


--
sctroy
------------------------------------------------------------------------
sctroy's Profile:
http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=484163