Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't find the right formula | Excel Worksheet Functions | |||
Find Formula | Excel Worksheet Functions | |||
Need to find the right formula | Excel Discussion (Misc queries) | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Find a Value and not a Formula | Excel Programming |