Move information between different workbooks?

Sp4rt4n

New Member
Joined
Sep 20, 2006
Messages
2
How would you get excel to compile from 20 different sheets onto a whole separate one?
If there was a way that would be awesome... Like... take information from B24 from fileone.xls and put it on B55 of compiled.xls
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Joined
Jul 30, 2006
Messages
3,656
Adjust the below formula:

='C:\Documents and Settings\?????\My Documents\?????\[filename.xls]Sheet1'!$A$1

1. adjust the ????? with the correct foldername(s)
2. adjust the filename with the correct file name
3. adjust the Sheet1 name with the correct sheet name
4. adjust the cell address $A$1 with the correct address from filename

Copy the adjusted formula (see instructions above) into cell B55 of 'compiled.xls':
='C:\Documents and Settings\?????\My Documents\?????\[filenone.xls]Sheet1'!$B$24


I am using Windows XP Professional SP2, and Excel 2003 SP2,

Have a great day,
Stan
 

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top