Microsoft QuickTips

Excel database?

Hello, i've a large excel file with about 5000 rows and about thirty columns. each row represents a fund and each column an attribute of the fund, either text or a number. i update this 'database' each month with a dozen new funds or so, so the number of rows keeps growing. the number of columns is fixed but then for each fund i've the monthly returns for the last 10 years or so, so that's another 120 columns with one new column each month. query : i need the data in other excel sheets but i do not like duplicating it. e one tells me about access but is it the only database i can use to work with excel? also one time set up, i do not want to use the access front end, i want the user to only use excel and the rest happens behind the scenes. i am not a programmer, i would probably use rentacoder to set it up for me. any advice would be welcome. thank you.
Answer
Why not put your other excel sheets in the same workbook as the data?

Related Products

Warning: DOMDocument::loadXML() [domdocument.loadxml]: Extra content at the end of the document in Entity, line: 2 in /home/gmartin/public_html/ukmicrosoftquicktips/includes/domxml-php4-to-php5.php on line 61

Fatal error: Call to a member function document_element() on a non-object in /home/gmartin/public_html/ukmicrosoftquicktips/includes/amazon.php on line 50