| Thread | Last Post | Replies |
|
| NETWORKDAYS including Saturday and Sunday | 15 May 2008 23:06 GMT | 2 |
How do I calculate two dates that will include the weekends?
 Signature Sherry Vinturella
|
| Countif Function | 15 May 2008 23:05 GMT | 1 |
Greetings Smart Excel Users, Will Excel allow me to create a range using multiple worksheets in a workbook? For example, my workbook contains 4 sheets. Can I setup my function to count within all 4 sheets or will it only allow me to count
|
| Losing Macro When Coping Sheets into a New Book | 15 May 2008 22:59 GMT | 3 |
I have a master spreadsheet that I'm using to create and send forms to different people. Once they receive the form, I want them to complete it and send it back to me. However when I do this, I'm copying the form from a blank template in one
|
| Formatting Question | 15 May 2008 22:43 GMT | 2 |
I have a sheet where the cells are fairly narrow so when more than a few characters are typed in, the text spills out into the next cells. Is there a way to "contain" the text to just the cell? I tried word wrap, but then it automatically readjusts the cell height to a very
|
| Conditional Formatting 2 rows only | 15 May 2008 22:41 GMT | 2 |
In Excel 2007, I can use a formula to highlight an entire row based on the value in one cell. What I cannot figure out is how to highlight two rows. It will highlight one every time!! What am I doing wrong? I highlight both rows
|
| SUMIF? | 15 May 2008 22:38 GMT | 2 |
have a worksheet that is from external data set: SN,City,Date, SU,MO,TU,WE,TH,FR,SA, QTY ,[weeknum] I add a column to put WEEKNUM based on date. the dates are generally the past 13 weeks
|
| Where can I find PHStat2 add-in for Excel 2007? | 15 May 2008 21:59 GMT | 1 |
This add-in is referenced in Stastics for Business and Economics but I can't locate it in Excel 2007.
|
| Wrap Text is not working correctly on one persons computer | 15 May 2008 21:21 GMT | 17 |
There is a gentleman in my office who is having a problem with text wrapping in a single cell. When he opens up a new Excel workbook and types in a sentence that goes past the cell width, the text appears on the screen spanning columns (as you would expect). When he formats the ...
|
| Macros in Excel (Office 2007) | 15 May 2008 20:48 GMT | 3 |
When I open a spreadsheet created in 2003 Excel, Office 2007 disables the associated macros. Is there a way to create macros in Office 2007 and save them so that every time I open the spreadsheet I can utilize those macros? Thank you!!
|
| payment due reminder | 15 May 2008 20:02 GMT | 1 |
In col "A" I have dates, col "B" amount,col"C" Status Msg: 1.05-jan-2008 -- 300.00-- Paid 2.11-feb-2008 -- 300.00-- Paid 3.02-mar-2008-- 300.00--paid
|
| Need a macro | 15 May 2008 19:57 GMT | 5 |
I'm working with a huge spreadsheet of over 20,000 rows. I need a macro that will copy the number in a cell down to the first cell with another number. In other words, cell A35 has, for example, 4500245842 in it. A42 has 450245989 in it. Then A85 has 450246910 in it. The ...
|
| Link cells and keep formatting? | 15 May 2008 19:56 GMT | 1 |
Is there any way to link a group of cells from one worksheet to another and keep the formatting? I can get things to link, but blank cells turn into Os and any cell color or merging cells is lost. Thanks
|
| Count after given condition is met | 15 May 2008 19:43 GMT | 7 |
would like your help for the following Need to count which and how many numbers appear after a given number ie After After After After After After
|
| Counting the number of characters in a cell | 15 May 2008 19:10 GMT | 2 |
I have a column called Part Number that has alphnumberic values that are anywhere from 6-12 characters. I need to calculate the number of characters in each cell. Is there a way to do this?
|
| Stop Symantec AV from quarantine my VBA | 15 May 2008 18:58 GMT | 4 |
Excel 2003 up to date What type of commands in Excel VBA does NAV assume relate to the Bloodhound Macro Virus. I assume that it does not like any command that deletes files - but there
|