(no brainer?) Getting cell values from other workbooks...

BeantownRich
03-21-2003, 07:04 AM
I have a spreadsheet in which one column contains a list of spreadsheet files. Each of those files has identical structure: a workbook called "Estimates" a value in cell F10 that I wish to pull into my spreadsheet.

Is this worthy of a macro or is there a much simpler method?

Thanks!

Mill
03-21-2003, 07:15 AM
I think you will need a macro. Look atthis page (http://www.j-walk.com/ss/excel/tips/tip82.htm) to get some code that should help you - especially if you don't want to have to open each workbook to do it.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum