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 and press enter. This
would ensure a link to that file
4. Then again in spreadsheet A1, copy the formula for all filenames
till X50.
5. Go to each formula cell and press F2 for editing the name of the
file. And just change the name from X1 to X50 while keeping the other links
intact.Thanx 'n' rgds,
Magesh-Mc
________________________________
From: gurumurthy sastry Kondury <gurumurthy.sas...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Friday, 3 April, 2009 1:37:51 PM
Subject: $$Excel-Macros$$ Help on a Formula in Excel
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 with the names of all these files.
Now I want to pull the data in the Cell 'T100' of each and every file to the
spreadsheet against each respective file name.
Is there any formula that can help me for this?
Thanks & Regards,
Gurumurty Sastry K H
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
