| Thread | Last Post | Replies |
|
| add blank space in cell if first name is not blank | 22 Aug 2006 21:37 GMT | 3 |
XL 2002 SP3 Win XP HE Follow-up to: microsoft.public.excel.worksheet.functions I have a list of names organized in table form.
|
| Find a specific string in a cell | 22 Aug 2006 20:46 GMT | 8 |
I would like to search all the cells that are not empty in column E for the words Account and New. If the cell does not have either of those words in it, I would like to delete that entire row, go to the next cell in column E and repeat this action until I arrive at an empty
|
| Sorting data held across different rows but in same column | 22 Aug 2006 20:41 GMT | 1 |
I have some data that contains the results of an online user survey The survey consisted of a series of multiple choice questions. Th answers were logged in a database and have been given to me as an Exce sheet.
|
| Prevent deletion of Excel File | 22 Aug 2006 20:10 GMT | 2 |
Is there any way to prevent deletion of an Excel file through Microsoft Explorer. The file is stored on a local drive.
|
| Only allow one user at a time | 22 Aug 2006 18:33 GMT | 7 |
We have an Excel spreadsheet that sits on the network. People need to open the file to be able to sign up for various duty rosters. We would like for the file to open for the first person. And then for any others after that, get a message that the file is in use
|
| Numbers to Words | 22 Aug 2006 18:10 GMT | 2 |
Is their a a function to convert numbers to english text e.g: $112.23 would become one hundred twelve dollars and twenty three cents (or something imiliar)
|
| Assign numeric value to a form check box? | 22 Aug 2006 18:02 GMT | 4 |
I'm building a form to track survey responses. I've got five colums, on for each response. The response for each of these is essentially boolean; Yes or No (True or False). The top of each column returns th SUM of that column so I can get a quick glimpse of the survey result
|
| How I can make a passward on the folder? | 22 Aug 2006 17:56 GMT | 2 |
I'm new user of Microsoft. plz tip me for getting knowledge.
|
| Slow RowHeight behavior | 22 Aug 2006 17:28 GMT | 2 |
I have a very strange behavior : on the same computer under windows xp, with excel 2003, but with two different logins, changing the size of a cell with the RowHeight property takes either 2-3 seconds or is almost immediate. The same time is taken when the height of a row is changed
|
| Hid and unhide and clear contents for specific columns at the same time | 22 Aug 2006 17:26 GMT | 1 |
I have a serious problem with excel programming and i am not able to figureout how to do the following funtions. I have 24 columns. names Jan -Dec ( Actual) then Jan- Dec (Forecast). There is one reference cell A1 ( for current month).
|
| Excel Woes | 22 Aug 2006 16:22 GMT | 1 |
I'd appreciate some help with my excel settings. Seems something happened ??hmmm, and now I cannot just double or single click on an excel icon and have itopen the workbook. It opens excel but it is blank with no workbook. I have to manually move to a folder and open from within ...
|
| Merging two sheets | 22 Aug 2006 16:20 GMT | 1 |
This is what I have
> Sheet 1 has two columns > Col1 ; Col2 |
| Selection for Code | 22 Aug 2006 16:13 GMT | 4 |
Hi, i will have a range, only celds than not have 999 for code Example: A B C 1 2 alfa 50
|
| Shaded Area in Lieu of Excel Charts | 22 Aug 2006 15:52 GMT | 2 |
I have a workbook with six worksheets in 3 pairs. Each pair contains a 'detailed data' worksheet and a 'summary' worksheet. The summary worksheet summarizes data from the detailed data. The summary worksheet also has a chart based on the data summary.
|
| Pivot Table Help | 22 Aug 2006 15:33 GMT | 2 |
Good Morning I have a pivot table set up and all is ok i have set up a macro to copy the data in the pivot table and to paste it sumwhere else and to sort it
|