Hi,

I have 100 financial statements in 100 seperate excel workbooks, how
do I pick and choose some data that exist in those workbooks, import
them into 100 different scorecards ( excel workbooks) and make
calculation such as financial ratios in those scorecards.


Eg


Book 1 ( Financial Statements); I have hundreds of rows of expenses
and others, but I only want to pick out the total expenses of admin,
total insurance expense, total payroll expenses, and bad debts which
will appear in scorecard 1 (excel workbook). In the scorecard 1, I
want to put some formulas to calculate financial ratios such as debt
coverage ratio, operating income per unit of apartment...


I have about 100 properties in 100 workbooks that needs calculated
monthly. How do I automate this?


Many thanks
Lan

Hi Positive

You can filter maybe, see the last code example on this page
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Positive" wrote in message oups.com...
Hi,

I have 100 financial statements in 100 seperate excel workbooks, how
do I pick and choose some data that exist in those workbooks, import
them into 100 different scorecards ( excel workbooks) and make
calculation such as financial ratios in those scorecards.


Eg


Book 1 ( Financial Statements); I have hundreds of rows of expenses
and others, but I only want to pick out the total expenses of admin,
total insurance expense, total payroll expenses, and bad debts which
will appear in scorecard 1 (excel workbook). In the scorecard 1, I
want to put some formulas to calculate financial ratios such as debt
coverage ratio, operating income per unit of apartment...


I have about 100 properties in 100 workbooks that needs calculated
monthly. How do I automate this?


Many thanks
Lan

On Aug 22, 4:42 pm, "Ron de Bruin" wrote:
Hi Positive

You can filter maybe, see the last code example on this pagehttp://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Positive" wrote in ooglegroups.com...
Hi,

I have 100 financial statements in 100 seperate excel workbooks, how
do I pick and choose some data that exist in those workbooks, import
them into 100 different scorecards ( excel workbooks) and make
calculation such as financial ratios in those scorecards.

Eg

Book 1 ( Financial Statements); I have hundreds of rows of expenses
and others, but I only want to pick out the total expenses of admin,
total insurance expense, total payroll expenses, and bad debts which
will appear in scorecard 1 (excel workbook). In the scorecard 1, I
want to put some formulas to calculate financial ratios such as debt
coverage ratio, operating income per unit of apartment...

I have about 100 properties in 100 workbooks that needs calculated
monthly. How do I automate this?

Many thanks
Lan- Hide quoted text -

- Show quoted text -

Ron,

I have tried and i have coped with 2 problems. I hope you could help
me with this.

Yes, I could merge the filtered data to a worksheet but I need to
import more than one search value and I also need the data to be
imported to seperate worksheets or workbooks not all in one worksheet.

Thanks

Is it not possible to merge all the data in one sheet and then split it in different sheets or workbooks

There is a exampel here that you can use after all data is in one sheet
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Positive" wrote in message ups.com...
On Aug 22, 4:42 pm, "Ron de Bruin" wrote:
Hi Positive

You can filter maybe, see the last code example on this pagehttp://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Positive" wrote in ooglegroups.com...
Hi,

I have 100 financial statements in 100 seperate excel workbooks, how
do I pick and choose some data that exist in those workbooks, import
them into 100 different scorecards ( excel workbooks) and make
calculation such as financial ratios in those scorecards.

Eg

Book 1 ( Financial Statements); I have hundreds of rows of expenses
and others, but I only want to pick out the total expenses of admin,
total insurance expense, total payroll expenses, and bad debts which
will appear in scorecard 1 (excel workbook). In the scorecard 1, I
want to put some formulas to calculate financial ratios such as debt
coverage ratio, operating income per unit of apartment...

I have about 100 properties in 100 workbooks that needs calculated
monthly. How do I automate this?

Many thanks
Lan- Hide quoted text -

- Show quoted text -

Ron,

I have tried and i have coped with 2 problems. I hope you could help
me with this.

Yes, I could merge the filtered data to a worksheet but I need to
import more than one search value and I also need the data to be
imported to seperate worksheets or workbooks not all in one worksheet.

Thanks