| Thread | Last Post | Replies |
|
| Can my excel doc be made into a calendar? | 27 Jul 2006 17:30 GMT | 1 |
I have an excel document that is fairly large in my opinion, is there a way to make the information in the excel doc populate a blank calendar?? Will need to take a combination of v and h look-up
|
| Importing data | 27 Jul 2006 17:19 GMT | 2 |
I'm building a datbase using Filemaker Pro for Macs. I can import data from an Excel spreadsheet into the datbase pretty seamlessly. I would like to send out an excel template and have people fill in the needed data (names, phone numbers etc.) I would like to merge all this info
|
| Vb ranges - Newbie question | 27 Jul 2006 16:51 GMT | 3 |
I am defining a range in an application: Set rnge = range("csv_update") this works great as long as the code is executed from the worksheet that the range is on. I would like to hide this sheet and execute the code on a sheet
|
| Cell/Worksheet references | 27 Jul 2006 16:04 GMT | 2 |
In Excel, how can I use the contents of a cell in a formula to direct to a specific worksheet. I have several worksheets and I want to extract the contents of a cell on a specific worksheet by using the contents of a cell to name the
|
| Excel can't find file | 27 Jul 2006 16:03 GMT | 7 |
I had an Excel file on my desktop, but when I moved it (cut and paste, copy and paste, or move with mouse) I get the following error (No Code) when I try to open the file. -'C:\file location.xls' could not be found. Please check the spelling
|
| Array Formula | 27 Jul 2006 15:50 GMT | 5 |
I need a formula to count disctints like = SUM(1/COUNTIF(C26:C46,C26:C46) but I need conditionals in the range and criteria of countif. I've tried this, but its not working.
|
| Range name table | 27 Jul 2006 15:44 GMT | 4 |
I want a list of all the defined names and their cell references. This used to be done in Lotus by Range/Name/Table. I can't find the equivalent in Excel. Can it be done. Thanks.
|
| Averaging compound numbers, e.g. Blood Pressur | 27 Jul 2006 14:15 GMT | 13 |
How does one average blood pressure readings? Please give an actual example, such as 152/65.
|
| Problem with minutes | 27 Jul 2006 13:38 GMT | 2 |
I have got a rota for bar staff, i have done that in excel. Day | Staff No. | Staff Name | Start Shift | Finish Shift | Hours | Minutes | Mon | 1 | John | 12:00 | 17:00 | 5 | 0 |
|
| Exporting add-in containing dll functions to other computers | 27 Jul 2006 12:42 GMT | 1 |
I developed an add-in for excel 2000 containing wrapper functions for a dll I made as well. Now I'm trying to export this add-in to another computer by copying the add-in to the other computers add-in folder(ie. C:\Documents and Settings\"YourUserName"\Application
|
| Excel slow down | 27 Jul 2006 12:41 GMT | 3 |
i have been using excel to fill in weekly time sheets, one sheet per week. All the workbook contains is a few formulas to work out and total my decimal hours each day, and a short macro to copy and clear a new sheet for a new week (with a userform to get the week start date).
|
| Convert text to time format | 27 Jul 2006 12:15 GMT | 2 |
I am unable to convert a piece of text that i copy paste from an external source to time format. Suppose I copy, "July 24 2006, 05:31 PM" and paste the same in excel it just assumes that that the entered data is text and I am unable to format the same. I need to convert this
|
| sheet names | 27 Jul 2006 10:00 GMT | 6 |
What returns the name of a worksheet in a workbook if you are in the workbook. for instance: findit(1) gives the name of sheet 1. Thanks
|
| Problem vertically aligning multiple rows with tickboxes added using VB. | 27 Jul 2006 09:30 GMT | 4 |
I searched for days to find the solution to adding a column of checkboxes down a table with 500 rows in it - a checkbox at the end of each row. The good news is that I eentually found that someone had posted a little VB code that did it nicely. I used some additional
|
| Excel 2003 upgrade | 27 Jul 2006 08:53 GMT | 3 |
What is this product on sale at the moment called 'Excel 2003 upgrade'? I have a workbook written in excel 2002 which contains lots of vba control elements and Visual Basic elements such as common dialog objects (it took me 4 months to write!)
|