| Thread | Last Post | Replies |
|
| User name , date and time | 26 Dec 2007 01:03 GMT | 2 |
Merry christmas . I need to insert a comment of user name, date and time automatically when a cell is changed or in next cell user name , date and time should come automatically.
|
| How to auto text colour change to green if logical function true? | 26 Dec 2007 00:05 GMT | 1 |
Hi Guys/Gals How can I get the text in a cell to automatically change colour from black to green when a logical function returns a 'TRUE' result? Please
|
| Paste cells without tabs | 25 Dec 2007 19:21 GMT | 1 |
I want to copy the contents of two horizotally adjacent cells, and paste the contents to rename a file in Windows Explorer. However, the clipboard retains a tab character between the text in the cells. How can I copy and paste the cells as run-on text, without a tab character
|
| copy and paste data (includes groups...) | 25 Dec 2007 19:06 GMT | 1 |
i need to copy spesific sheet from one workbook to another existing sheet in other workbook. both sheets includes Grouping. i wrote a code that copy and paste, but the actual result is that the
|
| e-mailing only few shheets | 25 Dec 2007 18:40 GMT | 2 |
How do e-mail only a few sheets (not the entire book)?
|
| Excel files in separate program windows | 25 Dec 2007 16:08 GMT | 25 |
Prior to Windows 2003, when opening different excel files, the files would open in their own Excel Programs windows. This feature still exists with Word 2003, but I have not seen this feature in Excel. Methods suggested to mimic this setting is to go to Tools -> Options
|
| New date based on one date field minus minutes in another field | 25 Dec 2007 16:05 GMT | 1 |
I have a worksheet that has 1 field with the full date, e.g. 12/25/2007 09:30 (field A) and another field that has minutes, e.g. 15. (field B) I want a formula that can tell me the new date/time if I take field A
|
| Amortization schedule and missed payments | 25 Dec 2007 01:05 GMT | 1 |
How can I add daily interest to my schedule, rather than only monthly. The purpose is to add daily interest to late payments.
|
| Adding intermittent rows to a spread sheet | 25 Dec 2007 00:30 GMT | 2 |
This is the structure of the file I have. It is one line per product No Desc Price Qty % 1 a $1.00 2 b $2.00
|
| Access or Excel?? | 24 Dec 2007 23:40 GMT | 4 |
This must be so simple and has probably been done a million times. I want a list of Artist that opens a list of cd's that opens a list of songs on the cd. I would rather do this in Excel as my Excel abilities far out weigh my Access abilities.
|
| # of allowable characters in Excel 2003 cell | 24 Dec 2007 23:34 GMT | 4 |
I have an Excel workbook that I am using to capture data from remote sites. They will be using a form to enter their data, but I just encountered a problem while testing. I pasted about 3400 characters into a textbox and in the AfterUpdate event attempted to use the following ...
|
| A macro code question from a novice | 24 Dec 2007 19:22 GMT | 2 |
The following is my code for a macro I want to run on a protected worksheet. My intent is for the macro to first unprotect the worksheet, then insert a copy of the person's scanned signature on to the worksheet after they answer the question "Are you sure you want to sign your ...
|
| Converting Cell References | 24 Dec 2007 19:02 GMT | 9 |
Is there a quick way to convert fixed cell references ($row$column) to eliminate the $ without editing the formula and deleting the $ one keystroke at a time? Sure would save me a lot of time. Thanks
|
| Compiled error in hidden module: DistMon | 24 Dec 2007 17:46 GMT | 1 |
I started getting this error message one day after using a file that someone else had modified. The message shows up when I start or close the Excel program Compiled error in hidden module: DistMon
|
| Copying Formulas Between Worksheets | 24 Dec 2007 17:35 GMT | 2 |
Have two worksheets. On sheet 1 in cell D48 have the following formula: =SUM((D9>C9), (F9>E9), (R9>Q9), (Z9>Y9), (AD9>AC9), (AF9>AE9), (AH9>AG9), (AN9>AM9), (AP9>AO9), (AR9>AQ9), (AX9>AW9), (BB9>BA9), (BD9>BC9), (BF9>BE9), (BN9>BM9), (O3>P3), (O4>P4), (O10>P10), (O14>P14), ...
|