Dear Guru,
I think this is possible.
Try the below steps :
1. Open your spreadsheet say A1
2. Open the first file in your folder (say X1 to X50)
3. In spreadheet A1,, in a specified cell next to the name of the file,
put a formula by typing = and go to cell T100 in file X1
Hi Gurumurty Sastry,
I have done the same thing as this before.
dim wk as workbook
For i=1 to number of files
set wk=workbooks.open (Filename:= Name of the file)
wk.range("T100").copy destination
:=workbooks("Spreadsheet").range(whatever you want)
Next i
Hope this can help
Kin
See attached file
Hope that helps
On Fri, Apr 3, 2009 at 12:07 PM, gurumurthy sastry Kondury <
gurumurthy.sas...@gmail.com> wrote:
> Hi All,
>
> Please help me with the below query.
>
> Suppose I have a folder Named "FOLDER". This folder has 50 Files. I have
> been maintaining a *Spreadsheet* wit
