I need a formula I can't find in help.
I am trying to transfer a sum of 3 data values from a closed spreadsheet
(2005 Expenses), from a specific worksheet within that spreadsheet (MVP Expenses) to another opened worksheet (Overhead) within a different spreadsheet (Payroll Expenses). Is this possible? I can't find a formula for this anywhere. Please let me know, Thanks, MV ) |
I need a formula I can't find in help.
in the open workbook add
=SUM('C:\MyDir\[2005 Expenses.xls]MVP Expenses'!A3:A5) -- HTH RP (remove nothere from the email address if mailing direct) "MVP Contracting" <MVP wrote in message ... I am trying to transfer a sum of 3 data values from a closed spreadsheet (2005 Expenses), from a specific worksheet within that spreadsheet (MVP Expenses) to another opened worksheet (Overhead) within a different spreadsheet (Payroll Expenses). Is this possible? I can't find a formula for this anywhere. Please let me know, Thanks, MV ) |
I need a formula I can't find in help.
Thank you very much Bob!
That worked great! MV "Bob Phillips" wrote: in the open workbook add =SUM('C:\MyDir\[2005 Expenses.xls]MVP Expenses'!A3:A5) -- HTH RP (remove nothere from the email address if mailing direct) "MVP Contracting" <MVP wrote in message ... I am trying to transfer a sum of 3 data values from a closed spreadsheet (2005 Expenses), from a specific worksheet within that spreadsheet (MVP Expenses) to another opened worksheet (Overhead) within a different spreadsheet (Payroll Expenses). Is this possible? I can't find a formula for this anywhere. Please let me know, Thanks, MV ) |
All times are GMT +1. The time now is 09:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com