Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
I have a bunch of invoices in a folder and need to get a total on how much I
made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
You can't do it easily with a single formula unless you only have a few
files. You can use a formula to each file and sheet and then add them up. =[yourfile.xls]yourworksheet!$D$34 Or, use a macro to get the data from each file and sum it in the cell of your choice. -- Don Guillett SalesAid Software "Betsy" wrote in message ... I have a bunch of invoices in a folder and need to get a total on how much I made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
='C:\[Book1.xls]Sheet1'!$D$34
Adjust the path and filename as needed........ Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: I have a bunch of invoices in a folder and need to get a total on how much I made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
So there is no way to generate it to do a whole folder? I have about 250
files... to eneter each name would take longer than opening each file to get the number i need.. "CLR" wrote: ='C:\[Book1.xls]Sheet1'!$D$34 Adjust the path and filename as needed........ Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: I have a bunch of invoices in a folder and need to get a total on how much I made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
You can always use a macro using DIR to open each fileget the dataand sum
as you go thru the files. mysum=mysum+filedata range("b3")=mysum -- Don Guillett SalesAid Software "Betsy" wrote in message ... So there is no way to generate it to do a whole folder? I have about 250 files... to eneter each name would take longer than opening each file to get the number i need.. "CLR" wrote: ='C:\[Book1.xls]Sheet1'!$D$34 Adjust the path and filename as needed........ Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: I have a bunch of invoices in a folder and need to get a total on how much I made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
This page of Ron de Bruin's may be of some help to you.........
http://www.rondebruin.nl/ado.htm Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: So there is no way to generate it to do a whole folder? I have about 250 files... to eneter each name would take longer than opening each file to get the number i need.. "CLR" wrote: ='C:\[Book1.xls]Sheet1'!$D$34 Adjust the path and filename as needed........ Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: I have a bunch of invoices in a folder and need to get a total on how much I made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add up the amounts from 1 cell in a folder of files
Another option is to create a link to the cell in each workbook
http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... This page of Ron de Bruin's may be of some help to you......... http://www.rondebruin.nl/ado.htm Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: So there is no way to generate it to do a whole folder? I have about 250 files... to eneter each name would take longer than opening each file to get the number i need.. "CLR" wrote: ='C:\[Book1.xls]Sheet1'!$D$34 Adjust the path and filename as needed........ Vaya con Dios, Chuck, CABGx3 "Betsy" wrote: I have a bunch of invoices in a folder and need to get a total on how much I made. Can i set up a formula that will import cell d34 from every file in the folder I specify and give me a total? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting cell data from numerous files in multiple folders???? | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Hyperlink more than one cell at a time? | New Users to Excel | |||
lookup cell content in multiple files | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |