| Thread | Last Post | Replies |
|
| Why do I get an error message hiding excel columns | 30 Oct 2007 11:01 GMT | 2 |
MY error message says it will not hide a column as it cant "shift objects of the page". I just want to hide the column!! Help?
|
| Dynamic SUM range | 30 Oct 2007 09:03 GMT | 8 |
I want to be able to SUM the last 4 values in row. I know the exact location of the last cell so this would appear to be my starting point and I would work backwards from thee. But the cells preceding it may contain a value or there may be a blank cell. There can only be a ...
|
| Naming of column index | 30 Oct 2007 08:57 GMT | 2 |
Dear experts, I've a marco in my worksheet which is used to show auto current date and time when something is filled in column A. The code is: Private Sub Worksheet_Change(ByVal Target As Range)
|
| Automatically pu date when cell is edited | 30 Oct 2007 07:32 GMT | 3 |
i want the date to be shown next to a cell when that cell is edited for the last time. I suppose is possible, but i cant find the command! Thanks in advance!
|
| Cursor Movement? | 30 Oct 2007 05:18 GMT | 10 |
How do I make the cursor got to a specific cell in a worksheet? The worksheet is for others to enter data and some cells are locked - I want the user to simply be able to hit the enter key and go to the next cell that needs data entered - in sequence - Any help with what I ...
|
| search across row for nearest value | 30 Oct 2007 02:57 GMT | 4 |
I am looking for a function that will search across a row of empty cells to find the one cell that has a value; and then bring that value to the formula. Additionally, I am looking for a function that will search across a row of empty cells to find the nearest cell that has a ...
|
| workday with month functions | 30 Oct 2007 02:19 GMT | 5 |
Hello, I have tried to create a date function that would give me the workday for any one month period,minus holidays, and would only display the workdays of one month by typing a date in C1. My worksheet does not allow me to display
|
| help PLEASE Urgent | 30 Oct 2007 02:05 GMT | 4 |
I have the following case that I am having problems with A B 1 Number Date 2 109956 1/08/1983
|
| consolidate data | 30 Oct 2007 00:36 GMT | 1 |
I have 2 seperate workbook each workbook contains certain numbers and $ amount. Here is how I want to result: before consolidate: workbook #1 Workbook#2
|
| how to avoid duplicate entries in column | 30 Oct 2007 00:25 GMT | 1 |
Hi thr, Can anyone help with this I want to get prompted if some enters duplicate entry into my excel sheet for a particular column. Thanks a lot,
|
| Formulas | 30 Oct 2007 00:08 GMT | 1 |
Can I create a formula that only counts cells that have been shaded or colored? For example, every week I run a report that lists all active "requests for information". The report shows the date the request was created. Can I color the ones created since the last report, and ...
|
| copying formulas | 29 Oct 2007 23:26 GMT | 2 |
All of a sudden, I am not longer able to copy a formula from one cell to another. Worse, if I change a cell in the formula (from 2+2 =4 to 2+3), the SUM still reads 4.
|
| Validation - Error message if equals Left formula | 29 Oct 2007 21:45 GMT | 6 |
I have a project code in column A formatted as general and the user should be entering 4 digits dash 3 digits (0001-000). In column B and C the user needs to break out each part of those numbers. In B they need to type 0001 and in C they type 000. I wanted to place a data ...
|
| How do I carry page numbers across sheets in Excel? | 29 Oct 2007 21:43 GMT | 1 |
I have multiple sheets that need to have the correct page numbers, but each sheet starts over at page 1, even when they are grouped. Any suggestions?
|
| Difference (weekdays) between two dates | 29 Oct 2007 21:37 GMT | 5 |
How do i calculate the difference between two dates? I only want to know "work-days": Monday - Friday. I know theres a calculation somewhere but cant find it.... Cheers,
|