Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto-populate spreadsheet based on database info?
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-populate spreadsheet based on database info?
On Monday, July 30, 2012 8:31:02 PM UTC-5, starnz wrote:
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| +-------------------------------------------------------------------+ -- starnz 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto populate many cells based on one cell | Excel Discussion (Misc queries) | |||
auto populate access database from an excel form | Excel Programming | |||
auto populate a field based on other fields | Excel Programming | |||
Automatically populate cells based on info in another worksheet | Excel Worksheet Functions | |||
Auto Populate Based on Other Selection | Excel Discussion (Misc queries) |