| Thread | Last Post | Replies |
|
| age calculation | 17 Jun 2005 17:41 GMT | 3 |
I need help with two things. I have a cell that contains an employee's date of birth. I need to be able to: 1) Have the value in another cell be the day that they turn 65.
|
| Repeat Data | 17 Jun 2005 17:00 GMT | 2 |
Is there a fast way to detect repeat entries in Access? Thanks
|
| Lookup help on inventory | 17 Jun 2005 16:39 GMT | 1 |
I am trying to keep a track of my inventory and wanting to use excel to calulate profit and inventory control. Let em try to explain below: Sheet 1 -> has product description, price I bought i for and quantity Sheet 2-> I want excel to lookup the item and price /quantity when I
|
| White Space in a Cell | 17 Jun 2005 15:03 GMT | 2 |
I'm collating a lot of spreadsheets that many other people have filled in onto one big spreadhseet template. My problem is that there is a free text cell and, because people dont know about the 'alt & enter' option, they've hit the space bar
|
| A little help, prob simple to anyone else | 17 Jun 2005 13:48 GMT | 5 |
Hi i am a very novice excel user and am wondering if anyone can help me with the problem below ?. Example sheet A B C
|
| Copying Checkbox Values into a different worksheet | 17 Jun 2005 13:04 GMT | 1 |
I'm trying to copy the value of several checkboxes to another worksheet. This works basically all fine by using the code below Sub EvaluateCB() ActiveWorkbook.Worksheets("Survey").Select
|
| Help needed to run macro - problems with certification. | 17 Jun 2005 12:57 GMT | 2 |
Argh!!! I think I may have created a macro to resolve an earlier problem, but when I try to run it I get... 'Macros in this workbook are disabled because the security level is
|
| installing add-in analysis toolpak | 17 Jun 2005 11:50 GMT | 3 |
I need to use the data analysis in Excel. I cannot install it, due to windows installer error 1635. I don't have the key: HKEY_LOCAL_MACHINE\Software\Classes\Installer\Products\
|
| CANNOT OPEN THE FILE | 17 Jun 2005 11:38 GMT | 1 |
Excel cannot access my file and the message is (Excel cannot access "Filename.xls". The Document may be read-only or encrypted), after I press Ok showing other message (cannot access 'file number'.)
|
| cell function will not recalculate | 17 Jun 2005 10:41 GMT | 1 |
Hey guys, i have a pivot table that i am resizing through vba and then i am refreshing a graph through vbs, then through normal excel functions i am using an offset to take the grand total from the pivot table and
|
| how do I share a file with another computer | 17 Jun 2005 10:04 GMT | 1 |
another person opened an excel - "phone log" now we want it in a shared file so I can open it at my desk - to update the information??? How do I do this??
|
| Excel Combo box help | 17 Jun 2005 09:59 GMT | 1 |
I have a simple question regarding how a combo box works in excel. I open a combo box from the Forms toolbar. Combo box means that I can either choose from the selection menu EITHER WRITE my own text.
|
| left far column plus and minus signs that expand rows | 17 Jun 2005 09:05 GMT | 2 |
I have a file outputted to excel that has in the far left column, left of the row numbers, a plus or minus sign that seems to group about 3 rows every so many rows. Is there a way I can clear all this grouping? What is it? Thanks!
|
| How to access dropdown list using keyboard? | 17 Jun 2005 07:47 GMT | 3 |
Can anyone please tell me how to access the dropdown lists I create using the "validation" window from the "Tools" menu? I usually access it with the mouse, but when I have to enter a lot of data I would rather use the keyboard as it is much faster. In Access I can access
|
| Question for dummy | 17 Jun 2005 04:34 GMT | 9 |
I am trying to do the following: - have and Excel file that can be modified by multiple users - when user modifies it on close, save it as HTML and - send an email (with Active Sheet in the email body)
|