| Thread | Last Post | Replies |
|
| Oracle to Excel | 30 Oct 2004 15:31 GMT | 2 |
Does any one know if you can create an excel file in Oracle wit multiple tabs -- Thomas Glove
|
| How move a picture by code (VBA)? | 30 Oct 2004 14:48 GMT | 2 |
Hi, I want to move a picture to a position, say, ColumnB and Row2 (or Cell B2) with its up-left coner the same as the cell. And I need resize the picture to fit in cell(B2:C3). What the VBA code to do this? I tried using record Macro, but the code is not easy to use.
|
| Can anyne help me with the problem!!!!! | 30 Oct 2004 14:42 GMT | 1 |
The basic problem for me is I don't know much about VBA or macros, as I am into PeopleSoft. When I am opening an excel report which is generated by a peoplesoft application. I am getting an error after I enable the macros and hit no to another warning to make any changes to ...
|
| Could do with a bit of help please. | 30 Oct 2004 14:40 GMT | 1 |
Ok, well, i have been set the task of making an invoice system that eve a noob could use. The invoice system is for a chemist. At the moment i have my main menu, a button on there links to custome details. Where the input box comes up like on the picture below, i mad
|
| type same information to differnt ares at the same time | 30 Oct 2004 14:34 GMT | 1 |
I NEED TO TYPE THE SAME INFORMATION TODIFFERNT PARTSOF THE WORKBOOK AT THE SAME TIME AND TO DIFFERNT FORMS
|
| can not see sheets | 30 Oct 2004 14:00 GMT | 6 |
I can not see the sheets although they exits. Even after I insert a new worksheet , i can not see it , i use them only by "Ctrl-Tab" . How can I solve this problem for this workbook ? (I have no problem with other workbooks)
|
| Sorting Columns into rows | 30 Oct 2004 13:15 GMT | 1 |
note: cross post I have no prior experience in writing macros in MS excel. I am willing to learn. My situation is:
|
| Pivot table | 30 Oct 2004 12:49 GMT | 1 |
I wish to create a pivot table using four columns such as Category Gross GST Nett Phones $200.00 $25.00
|
| Filter suddenly limited | 30 Oct 2004 09:09 GMT | 1 |
I have an excell file that is about 2000 rows. I use the filter t locate rows with same names, The filter now only works thru row 1256. Any suggestions what is causing this --
|
| invalid page fault | 30 Oct 2004 07:30 GMT | 4 |
In my Office 2000 program, when I try to open excel the following message appears. invalid page fault in module EXCEL.EXE at 018f:30026d89. I have tried to repair this file through the disk and also reinstall it. I still get the same message. Is there a patch to this problem and if ...
|
| UPC Equation | 30 Oct 2004 04:12 GMT | 1 |
Okay awesome. Thanks so much for the help guys. I went with some hidde cells to insert the extra parts of the formula. Now, is there a way t make it apply to each and every field in Column A? and Column B? Thanks
|
| A problem about the function COUNTIF | 30 Oct 2004 02:08 GMT | 1 |
I encountered a problem when I use the function COUNTIF. Column A (A1: A1000) is a column of numbers and B1 is another number. I would like to record how many entries in column A is bigger than B1 in another cell C1. I tried to use the formula
|
| Help in moving row of information in excel format | 30 Oct 2004 02:05 GMT | 1 |
I am trying to set up a production flow excel sheet. I would part of a row of information to move to the next work sheet when one specific column in the row is filled in. To move client information from one department to the next when it is initialed out of the first ...
|
| Limiting Input in Cells to those in List | 30 Oct 2004 00:09 GMT | 2 |
I want to limit input in each cell in a column to a group of options, eg, "Mary, John, Bob". I'd like to have this list drop down, like a combo box, but since this will be for many cells, I like to do this as a formula
|
| Excel File Association hiccup | 29 Oct 2004 23:57 GMT | 2 |
Since installing Windows XP SP2 I have partially lost the File Association between XLS and Excel 2002. When I double-click on an XLS file, Excel will open but with a completely blank window(not a blank workbook). I can then load the file with File Open. Other Office
|