Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

Can I do this in Excel and/or Access? 'This' is a bit complicated so it's explained inside. [more inside]
posted by nooneyouknow on Jul 17, 2009 - 13 answers

How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
posted by elgilito on Apr 22, 2009 - 5 answers

I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template. [more inside]
posted by Inkoate on Oct 11, 2008 - 1 answer

How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted by desjardins on Jan 25, 2008 - 8 answers

I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
posted by dance on Nov 5, 2007 - 2 answers

I need recommendations of some books for Excel and Access. I'm looking for something referency, but still readable. [more inside]
posted by chrispy108 on Oct 8, 2007 - 6 answers

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 answers

How do you create text files from a spreadsheet? [more inside]
posted by bigmusic on May 2, 2007 - 6 answers

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet. [more inside]
posted by elle.jeezy on Jan 3, 2007 - 3 answers

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047 on Nov 6, 2006 - 4 answers

OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie on Aug 22, 2006 - 4 answers

It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
posted by godawful on Feb 10, 2006 - 9 answers

Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted by clgregor on Sep 2, 2005 - 5 answers

I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?
posted by bonehead on Aug 19, 2004 - 10 answers