| Thread | Last Post | Replies |
|
| Message Box | 12 Apr 2008 20:24 GMT | 3 |
All, below is the code that I use to delete contents of the open sheet. How do I make it ask or show a message box with 'Yes' or 'No' asking to delet or not? Thanks in advance. Cells.Select
|
| Days between dates | 12 Apr 2008 18:27 GMT | 12 |
Sorry Guys, I have looking around on a bunch of websites on calculating days between dates (sort of) and it's almost working but I need it to really work. I need a cell to return the number of days a patient was on a ventilator.
|
| How to protect one sheet | 12 Apr 2008 16:45 GMT | 3 |
I have a workbook with 4 pages, I want to deny access (to view) to just one of those sheets but allow access to the other 3. Is this possible thanks
|
| How to analyze blood pressure data | 12 Apr 2008 15:04 GMT | 3 |
My doctor suggested I get a home blood pressure monitor and take a reading every day or so. I put the data in a Word table and am amazed at the variability. I am wondering if someone can tell me what type of analyses I should
|
| More than 65,000 rows - Crash on manipulate | 12 Apr 2008 14:28 GMT | 3 |
I'm using excel 2007 with vast amounts of data - file listings of 300,000 files, database dumps that i need to analyze, which have 20 columns and 100,000 rows, etc - and I find that i am crashing excel pretty often.
|
| Outdate alert | 12 Apr 2008 05:47 GMT | 2 |
Trying to set up a file where I can list items in column a with their out dates in column b and would like to set it up so I get an alert one month before the outdate. I was given this formula but get an message that says there is an error in it. any idea what is wrong.
|
| Calculated Field based on 2 Running Totals | 12 Apr 2008 05:23 GMT | 1 |
I need to make a calculated field based on two running totals: Week Metric1 Metric2 Ratio 1
|
| How to fill cells down and change function | 12 Apr 2008 05:21 GMT | 2 |
Ok, weird question...a co-worker has been teaching me a lot about Excel but his computer is set up in Spanish (he's from Mexico). There is a 2-part command that is: Shift + Ctrl. + down arrow (to fill all cells down that have values)
|
| Sorting and Column Headers | 12 Apr 2008 05:10 GMT | 4 |
When you have a range selected and there are not values in all columns of the top row, the default behavior of Sort will be to not include a column header. However, I have a data range that DOES have column headers across the range, and yet, whenever I go to sort, it does not
|
| Office Suite Excel to Works Excel | 12 Apr 2008 03:45 GMT | 6 |
I'm trying to copy data from Office Suite to Works but the data won't paste the same way and I can't figure out to format it to match the original document. Is there a way? Any suggestions?
|
| Lookup and Reference Lists | 12 Apr 2008 00:26 GMT | 1 |
Here's the situation. In Sheet1 I have a list of about 1200 items in following format: T0000 ----
|
| How do I access my data tools? | 12 Apr 2008 00:02 GMT | 2 |
Why can't I access all of my tools in the Data tab? I have access to them in another document but not a second document.
|
| Excel 2007 - Conditional Formatting copy/paste errors | 11 Apr 2008 23:14 GMT | 2 |
I find that if I create a conditional format at one cell and then copy that to a multitude of others, the variable references within the conditional format will not adjust accordingly. For example: At cell A1, I have the conditional format of "=IF(A1>0,1,0)". If I copy
|
| How to learn to write macros | 11 Apr 2008 22:31 GMT | 3 |
Can someone tell me the links where i can learn how to write macros - i would prefer to do simple things with my macro such as copy information from several sheets to one sheet, find the average,sum..etc of cell values from different worksheets
|
| Unhide many sheets | 11 Apr 2008 21:24 GMT | 3 |
How do I unhide 200 sheets in a workbook ?
|