| Thread | Last Post | Replies |
|
| Combining multiple cells in column to relate to one cell in 1st co | 21 Feb 2008 19:44 GMT | 2 |
So I am trying to figure out how to combine, merge, or expand cells so that the following info remains together, even if I sort names alphabetically when it’s all complete. These are the categories….
|
| Hide commandbutton? | 21 Feb 2008 19:40 GMT | 2 |
I have a commandbutton on my worksheet titled menu. When pressed a userform appears. How do i get the commandbutton to disappear when the userform appears and reappear when the userform is closed.
|
| Macro Help | 21 Feb 2008 19:03 GMT | 1 |
Hello, I'm trying to create a macro so that two columns are inserted every 12 columns starting with Column C. Any help would be appreciated. Thanks.
|
| lost my formulas | 21 Feb 2008 18:59 GMT | 2 |
I saved my worksheet. When I went back and highlighted a cell.....it didn't show me the formula I used in the fx header.....and I forgot the formula. please help
|
| Question about returning some values from highest to lowest | 21 Feb 2008 18:39 GMT | 3 |
I have a groupe of numbers, and all I want to do is be able to return the highest of the group, then the second highest, third highest... and so on. Im sure its an easy answer, but I just dont know how to do it. Can anyone help me?
|
| change date formatting in destination cell | 21 Feb 2008 18:36 GMT | 2 |
I have a date cell that I want formatted "January 1, 2008"; I want to pull that date into another cell to minimize error, but I want it to be formatted "1/01/08" because of space limitations. I can't figure out how to change the date format in my destination cell - is this even ...
|
| recording macro | 21 Feb 2008 18:19 GMT | 1 |
I am trying to record a macro while I use "data analysis" but the code that it is giving me does not record the ranges that I select. How do I enter the ranges that I am trying to select with in the data analysis? This is the code it returns after i stop recording:
|
| Change all comments size in the same time in my sheet | 21 Feb 2008 18:07 GMT | 1 |
Change all comments size in the same time in my sheet
|
| Flagging data in Excel | 21 Feb 2008 18:02 GMT | 1 |
I have a query from MS Access containing user ids. In addition, I have an excel spreadsheet containing user ids. I would like to take the results from the Access Query and match them to the excel file and somehow flag the matches in excel with some sort of tag (ie;color, font, ...
|
| Marketing match-back analysis help | 21 Feb 2008 17:48 GMT | 1 |
I'm trying to match common records in two different lists for a "match-back" analysis for my marketing efforts. I have a list of respondents to my kits, and a list of customers. I want to find how many customers are in the kit list. My database people used to do this, but now I'm ...
|
| Why doesn't INSTREV work for me? | 21 Feb 2008 17:44 GMT | 13 |
I'm using INSTREV to retrieve the location of a character in a string by searching from the end of the string. When I type the following in the immediate window: ?InStrRev("1234567-89", "-")
|
| Goal seek - Is there a bug? | 21 Feb 2008 17:42 GMT | 1 |
I have a relatively simple model but when I try to use the goal seek function it runs the maximum number of iterations and finally no solution comes up. Please note that a) THERE IS a solution. I found it by trial and error.
|
| Woorkbook toolbar | 21 Feb 2008 17:19 GMT | 2 |
I tried creating a custom toolbar for a workbook with a button to execute a macro. It appeared to be working but now I notice that once the workbook is used once the toolbar appears in Excel for all other workbooks? I only want it attached to the selected workbook in question ...
|
| Spreadsheet Bloating | 21 Feb 2008 17:12 GMT | 1 |
I have/had a workbook which was 14MB. I did a very little amount of progamming (20 lines or less) and added a simple toolbar with 1 button and now it is 25MB? I then manually copy everything to a new workbook and saved it and it is
|
| How to set a specific column always visible in the excel sheet | 21 Feb 2008 17:10 GMT | 1 |
How to set a specific column always visible in the excel sheet
|