| Thread | Last Post | Replies |
|
| Comparing text in cells for differences | 27 Aug 2008 12:00 GMT | 4 |
I want to compare some text in a1 with text in b1 and have Excel place the differences in c1. Is this possible? The EXACT function only tells me if they are alike or not with a true or false, even if the only difference is a capital letter. I could place the text in one sheet ...
|
| Drop down lists in cells.....I think!!!! | 27 Aug 2008 11:30 GMT | 4 |
Can anyone help with my little problem. I need to find out how to add drop down lists to individual cells. If you can picture this example...... I have a list with 10 items....in any given cell I would like a control box
|
| Tick boxes in excel | 27 Aug 2008 11:21 GMT | 2 |
I'm doing a sort of questionnaire for work and was wondering if you could do tick boxes or radio buttons for people to select in excel? Thanks Rachel
|
| Data Validation | 27 Aug 2008 10:42 GMT | 3 |
Using the following formula in data validation will avoid the user entering duplicate entries, however, I don't understand what the A1 is for.... can anybody explain to me? Thank you.
|
| How to delete rows in visual basic | 27 Aug 2008 09:43 GMT | 3 |
I would like to delete rows for a specific criteria in visual basic, but I don't know how. I have filtered my data, and now I would like to delete the data that did not pass the filter. Thanks for helping!
|
| General reference source | 27 Aug 2008 09:13 GMT | 2 |
I need a macro code for a general sheet reference to a single column. In my excel file I have about 15 sheets. In every sheet I would like to make a graph of the same colum (F column). It should be possible to put this in a macro, but I don't see how I can refer in my macro to ...
|
| Deleting rows in two columns with a code in visual basic | 27 Aug 2008 09:10 GMT | 5 |
I have a problem with making a code in visual basic. I would like to make a code that deletes all rows in which the value of column G starts with a ‘W’ (after ‘W’ there is a number, example: W-123-231). I can do this, but now comes the most difficult thing.
|
| Loop till value changes | 27 Aug 2008 09:07 GMT | 2 |
I am making a code in visual basic that has to loop till the value in column C changes. But I don't know how I can put in the code "loop till value in column C changes". Would be great if someone could help me! Thanks!
|
| Excel IF AND question | 27 Aug 2008 08:30 GMT | 8 |
I need to place a formula that says: If H8's date is past, and I8 is blank, turn cell RED. Can someone tell me how to enter this formula?
|
| Linking duplicate file | 27 Aug 2008 06:50 GMT | 1 |
Hi, I have an excel file stored in Location 1, and would like to duplicate this file into Location 2. Edit and update will be done to the original file in Location 1 only. I would like to link the duplicated file in Location 2 to
|
| How do I attach a jpeg file I've saved so I can open it | 27 Aug 2008 06:42 GMT | 2 |
When I try to attach a scanned document I have saved as a jpeg it won't let me open it when I click on it. I also tried it with a pdf and I can't open it eithor. Please Help if you can.
|
| Printing | 27 Aug 2008 06:40 GMT | 3 |
I have a problem printing with excel. I use office 2007, and it happens most times, that when I want to print, only half the page (lower half) prints. If I print to pdf it either prints half or only the header and footer, but the rest is empty. Does anybody know a solution to ...
|
| to unlock password | 27 Aug 2008 05:05 GMT | 1 |
i have forgot my password of protect file of excel how can i open it ?
|
| Macro: Delete Row Above Last | 27 Aug 2008 04:31 GMT | 3 |
I am trying to create a macro to delete the line above my totals line (which is the last line in the sheet). I am using the following macro to delete a line but am not sure how to modify it. Any advice is appreciated.
|
| Need a drop down list to auto fill other cells... | 27 Aug 2008 03:16 GMT | 1 |
Hopefully there is an easy solution. I am working on a custom expense sheet. I am trying to have a drop down menu of cost codes for the certain job sites. I can create one list with all the info in the single cell, but I would like to do is when you select the job side that ...
|