| Thread | Last Post | Replies |
|
| Open an SCV file | 29 Oct 2004 13:23 GMT | 1 |
On some computers, if I open the *.csv file it opens correctly in Excel as I import it in Excel, but on other computers I have to open the Excel and import data... *.csv file. Please tell me if there is an option in Excel to set this.
|
| Curly Brackets In Formulas | 29 Oct 2004 12:57 GMT | 2 |
I'm trying to copy formulas from one spreadsheet to another similar to the one below, but the curly brackets disappear, rendering the formulas inoperable (in the original document, they compare values in one range of cells against another, count the cells that match as 1, and adds ...
|
| Desperately seeking some help here! <PLEASE> | 29 Oct 2004 10:27 GMT | 1 |
I have had some trouble on a project I have been working on for some time. I have tried numerous approaches, each with undesired results. (VAB Code) The project I am working on has become quite complex, so rather
|
| How put "F2" key in a macro? | 29 Oct 2004 10:11 GMT | 6 |
Am using MS Excel XP (2002). All I want to do is make a short macro to, in effect, press F2 (to EDIT the cell), then let's say delete the first character of the cell and change it to let's say X, like this... Before:
|
| Help with lookup issue... | 29 Oct 2004 09:32 GMT | 1 |
Thanks for the answer JulieD! I'm starting each month with a workbook with pre-made worksheets fo each day's automated report, and a premade worksheet for each Agent. Each day the report for that day Is pasted into the proper day'
|
| Error 1004 Workbooks.Add Inplace-Activation | 29 Oct 2004 09:09 GMT | 1 |
I don't know if I am in the correct forum but here it comes any way Sub AddWorkBook() ThisWorkbook.Application.Workbooks.Add
|
| Remove the Worksheet Tab | 29 Oct 2004 08:46 GMT | 1 |
Is it possible to remove from view the worksheet tabs at the bottom without hiding the actual worksheet itself? I want the users to navigate around the workbook via macros instead Thanks
|
| How does the TRANSPOSE command work? | 29 Oct 2004 07:46 GMT | 2 |
For the life of me, i can't figure it out. I've tried highlighting, not highlighting, i'm just stupid. if a1:c1 = 1,2,3 and i want a2, a3, a4 = 1, 2, 3, step by step (including
|
| How do I insert a check box? | 29 Oct 2004 06:55 GMT | 1 |
I'm trying to insert a new check box into a cell in the worksheet. Can this be done? I'm not very good at this. Please email me at: wsegni@zionsbank.com if you can help me because the old email address is not working correctly. Thanks!
|
| Please help | 29 Oct 2004 06:50 GMT | 1 |
Hello, I have a small worksheet that is complete and work great. It consists of 2 cells where users have to enter 2 number and then the other 8 calculations are figured out for them. This is all complete thanks to one nice user who helped me with the last formula. The
|
| Creating column content based on another column's keyword(s) | 29 Oct 2004 06:24 GMT | 1 |
Max, That scriptlet was very useful, and easily tweakable to work in myria applications. Thx!
|
| How to Print a Comment | 29 Oct 2004 06:20 GMT | 1 |
hi, i do a print a worksheet with comments on it?
|
| Column Lables? | 29 Oct 2004 06:06 GMT | 1 |
Accross the top of the spreadsheet, the names of each column used to be letters(a,b,c,...z,aa,ab,ac...etc). However. somhow I managed (without realizing it) to change them all to numbers. It is makiing my function making hard; I want it back but I dont know how. Please help!
|
| Copying a set of info from a different sheets | 29 Oct 2004 04:12 GMT | 1 |
Hi, please help I really need your help. I am trying to copy a set of info from eg. sheet2 to sheet1. The problem is, I have to create a drop down list in sheet1 to brin
|
| incremenT CountIF Value | 29 Oct 2004 03:08 GMT | 2 |
i have the following COUNTIF formula - the range stays the same but th value its searching for changes each time going up to 100 - i don' really want to type in 1 -100 in my seperate count if functions i there a better way?
|