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
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
you can link cells like thisOriginally Posted by Sp4rt4n
put in B55 of compiled.xls
='[fileone.xls]sheet1'!$B$24
let me know if you require something different.
do not forget to provide data references of your workbooks.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks