extracting data

ehsas69

Board Regular
Joined
Jan 10, 2004
Messages
221
I would like to fill the following worksheet based on data available in the differents file

I have sixteen months file which names as jan2005 to jun2005

i want formula or macro to be put in below workseet which will check the data in the sixteen months data and take the information from jan2005 a2 cell and put in b2 and a3 to c2 and a4 to e2 and b5 to f2 and a6 to g2 and a7 to h2 and a8 to i2 and for feb2005 the data to be filled in row 3.

thanks
Book1
ABCDEFGHI
1MONTHDATA1DATA2DATA3DATA4DATA5DATA6DATA7DATA8
2JAN'04
3FEB'04
4MAR'04
5APR'04
Sheet1
 
Yes, you can have them in a different folder. Actually, since you're using INDIRECT.EXT, I believe you'll need to specify the files' path so that the file can be closed...

=INDIRECT.EXT("'C:\Documents and Settings\user\My Documents\["&TEXT($A3,"mmmyyyy")&".xls]Sheet1'!"&CELL("address",INDEX($B:$B,COLUMNS($B3:B3)+1)))

Hope this helps!
 
Upvote 0

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top