I need to automatically take data from another excel file. At the moment,
I've put a formula into the cells to say that A1 = Cell A1 of 'File
Directory + Name'. This means that I have to keep dragging down the formulas
on the worksheet to get the latest rows of data. Is there a macro (or
something else) that will allow me to update the data automatically without
having to copy the formulas down?

You could have a macro copy the formulas down

--
Regards,
Tom Ogilvy


"Thriller" wrote in message
...
I need to automatically take data from another excel file. At the moment,
I've put a formula into the cells to say that A1 = Cell A1 of 'File
Directory + Name'. This means that I have to keep dragging down the
formulas
on the worksheet to get the latest rows of data. Is there a macro (or
something else) that will allow me to update the data automatically
without
having to copy the formulas down?

Could you help me with the macro please?

"Tom Ogilvy" wrote:

You could have a macro copy the formulas down

--
Regards,
Tom Ogilvy


"Thriller" wrote in message
...
I need to automatically take data from another excel file. At the moment,
I've put a formula into the cells to say that A1 = Cell A1 of 'File
Directory + Name'. This means that I have to keep dragging down the
formulas
on the worksheet to get the latest rows of data. Is there a macro (or
something else) that will allow me to update the data automatically
without
having to copy the formulas down?

How do you determine how far to copy them?

Otherwise

sub Applyformula()
Range("A1").Resize(1000,20).Formula = "='C:\My
Folder\[MyFile.xls]Sheet1'!A1"
End Sub

or

Sub Applyformula
res = InputBox("Enter Number of Rows")
if res < "" then
if isnumeric(res) then
Range("A1").Resize(res,20).Formula = _
"='C:\My Folder\[MyFile.xls]Sheet1'!A1"
end if
end if
End sub

--
Regards,
Tom Ogilvy


"Thriller" wrote in message
...
Could you help me with the macro please?

"Tom Ogilvy" wrote:

You could have a macro copy the formulas down

--
Regards,
Tom Ogilvy


"Thriller" wrote in message
...
I need to automatically take data from another excel file. At the
moment,
I've put a formula into the cells to say that A1 = Cell A1 of 'File
Directory + Name'. This means that I have to keep dragging down the
formulas
on the worksheet to get the latest rows of data. Is there a macro (or
something else) that will allow me to update the data automatically
without
having to copy the formulas down?