Auto-populate spreadsheet based on database info?

[starnz]

Hi,

I have populated a database(Expense) with 4 columns(Date, Description
Amount, Type) listed by date over several months. I have anothe
tab(Expense A) where I would like this information to be displayed i
matrix form by month. The matrix is based on the different Types, 7 i
total. So the matrix has 10 columns(Date, Description, 7 Types
Subtotal) and would be listed by Date as well. My goal is to easily sho
the amount spent among the 7 Types on a month to month basis using th
matrix and an chart.

My question is how can I use the info from the database to automaticall
populate the entries into the matrix. For example, if the database show
a Marketing entry in the Type column I would like that Marketin
info(Date, Description, Amount) to populate in the matrix. I would lik
the amount from the database to populate in the appropriate column i
Expense A based on the Type from the database. The Types from th
dropdown in the database are matched to the 7 Types from Expense A i
the Income A tab.

I understand this represents a redundancy of info but if anyone ha
ideas to accomplish this it would be greatly appreciated! I hav
attached the file for reference..

+-------------------------------------------------------------------
|Filename: Accounting.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=515
+-------------------------------------------------------------------

 

[Don Guillett]

Hi,



I have populated a database(Expense) with 4 columns(Date, Description,

Amount, Type) listed by date over several months. I have another

tab(Expense A) where I would like this information to be displayed in

matrix form by month. The matrix is based on the different Types, 7 in

total. So the matrix has 10 columns(Date, Description, 7 Types,

Subtotal) and would be listed by Date as well. My goal is to easily show

the amount spent among the 7 Types on a month to month basis using the

matrix and an chart.



My question is how can I use the info from the database to automatically

populate the entries into the matrix. For example, if the database shows

a Marketing entry in the Type column I would like that Marketing

info(Date, Description, Amount) to populate in the matrix. I would like

the amount from the database to populate in the appropriate column in

Expense A based on the Type from the database. The Types from the

dropdown in the database are matched to the 7 Types from Expense A in

the Income A tab.



I understand this represents a redundancy of info but if anyone has

ideas to accomplish this it would be greatly appreciated! I have

attached the file for reference...





+-------------------------------------------------------------------+

|Filename: Accounting.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=515|

+-------------------------------------------------------------------+

I think you need to provide more detail about the logic of your project and before/after examples. send file with complete explanation to dguillett1 @gmail.com