software

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?

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

quot;Betsyquot; gt; wrote in message
...
gt;I have a bunch of invoices in a folder and need to get a total on how much
gt;I
gt; made. Can i set up a formula that will import cell d34 from every file in
gt; the folder I specify and give me a total?
='C:\[Book1.xls]Sheet1'!$D$34

Adjust the path and filename as needed........

Vaya con Dios,
Chuck, CABGx3
quot;Betsyquot; wrote:

gt; I have a bunch of invoices in a folder and need to get a total on how much I
gt; made. Can i set up a formula that will import cell d34 from every file in
gt; the folder I specify and give me a total?

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..

quot;CLRquot; wrote:

gt; ='C:\[Book1.xls]Sheet1'!$D$34
gt;
gt; Adjust the path and filename as needed........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Betsyquot; wrote:
gt;
gt; gt; I have a bunch of invoices in a folder and need to get a total on how much I
gt; gt; made. Can i set up a formula that will import cell d34 from every file in
gt; gt; the folder I specify and give me a total?

You can always use a macro using DIR to open each filegt;get the datagt;and sum
as you go thru the files.

mysum=mysum filedata
range(quot;b3quot;)=mysum
--
Don Guillett
SalesAid Software

quot;Betsyquot; gt; wrote in message
...
gt; So there is no way to generate it to do a whole folder? I have about 250
gt; files... to eneter each name would take longer than opening each file to
gt; get
gt; the number i need..
gt;
gt; quot;CLRquot; wrote:
gt;
gt;gt; ='C:\[Book1.xls]Sheet1'!$D$34
gt;gt;
gt;gt; Adjust the path and filename as needed........
gt;gt;
gt;gt; Vaya con Dios,
gt;gt; Chuck, CABGx3
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Betsyquot; wrote:
gt;gt;
gt;gt; gt; I have a bunch of invoices in a folder and need to get a total on how
gt;gt; gt; much I
gt;gt; gt; made. Can i set up a formula that will import cell d34 from every file
gt;gt; gt; in
gt;gt; gt; the folder I specify and give me a total?
This page of Ron de Bruin's may be of some help to you.........

www.rondebruin.nl/ado.htm

Vaya con Dios,
Chuck, CABGx3
quot;Betsyquot; wrote:

gt; So there is no way to generate it to do a whole folder? I have about 250
gt; files... to eneter each name would take longer than opening each file to get
gt; the number i need..
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; ='C:\[Book1.xls]Sheet1'!$D$34
gt; gt;
gt; gt; Adjust the path and filename as needed........
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Betsyquot; wrote:
gt; gt;
gt; gt; gt; I have a bunch of invoices in a folder and need to get a total on how much I
gt; gt; gt; made. Can i set up a formula that will import cell d34 from every file in
gt; gt; gt; the folder I specify and give me a total?

Another option is to create a link to the cell in each workbook
www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;CLRquot; gt; wrote in message ...
gt; This page of Ron de Bruin's may be of some help to you.........
gt;
gt; www.rondebruin.nl/ado.htm
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Betsyquot; wrote:
gt;
gt;gt; So there is no way to generate it to do a whole folder? I have about 250
gt;gt; files... to eneter each name would take longer than opening each file to get
gt;gt; the number i need..
gt;gt;
gt;gt; quot;CLRquot; wrote:
gt;gt;
gt;gt; gt; ='C:\[Book1.xls]Sheet1'!$D$34
gt;gt; gt;
gt;gt; gt; Adjust the path and filename as needed........
gt;gt; gt;
gt;gt; gt; Vaya con Dios,
gt;gt; gt; Chuck, CABGx3
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Betsyquot; wrote:
gt;gt; gt;
gt;gt; gt; gt; I have a bunch of invoices in a folder and need to get a total on how much I
gt;gt; gt; gt; made. Can i set up a formula that will import cell d34 from every file in
gt;gt; gt; gt; the folder I specify and give me a total?