| Thread | Last Post | Replies |
|
| Question: Automatically Filling Cells by Identifying Row | 17 Sep 2004 02:30 GMT | 1 |
I've made a fax sheet in excel with a number of blocks to be filled. Company name, ph#, fax number, part #, etc. All this information is present on another sheet when I input my order. The first column on that sheet is my Purchase Order Number (IE TT4153). The
|
| Read only? | 17 Sep 2004 02:16 GMT | 1 |
I crated a merge document in Word and have my data in Excel. When I open the data doc to make changes I always get a message saying it is read only and that I will be notified when it is available. I get around it by saving a copy, then deleting the original and renaming the copy.
|
| Copying a formula to another page | 17 Sep 2004 01:43 GMT | 3 |
I am a new user to Excel. I am working with a spreadsheet that and I want to pull the formula for one spreadsheet to another. What are the procedures for copying the formula. Thanks,
|
| Excel 2003 very, very slow compared to Excel 97 | 17 Sep 2004 00:52 GMT | 1 |
I have an excel sheet with some tables, some vloopup, and some images that are swapped depending on some calculations. In Ecxel 97 this sheet runs good, no delays are noticeable. When I load the same sheet on a similar computer with excel 2003, the sheet
|
| Missing Command Buttons | 17 Sep 2004 00:07 GMT | 1 |
For some reason on one machine the VBA Command Buttons that are embedded on some sheets will not appear but the built in forms buttons for Excel will appear. Any ideas?
|
| Comments: arrow connector formatting/preferences | 16 Sep 2004 23:58 GMT | 1 |
Is there any way to specify that the arrow that connects the comment to the cell be attached to one of the other corners rather than just the top right cell corner? Thanks, Bryan
|
| Comparison | 16 Sep 2004 23:53 GMT | 2 |
I am running SQL reports to bring up clients that stop using my servic after 1 month. 600 come up. I then contact them all and then usuall 45% come back. I have no way of finding which of my 600 make up tha 45%. All this is being tracked in excel. This would be of use i
|
| Accessing Color palette values | 16 Sep 2004 21:49 GMT | 1 |
Objective ******* I'm developing an utility where the user is given a option to select color. Then certain cells in the excel will be filled with that color
|
| Please,I need help ASAP | 16 Sep 2004 21:07 GMT | 2 |
I created a Named Range containing a series of product code descriptions, which I need to use for validating data entry on another column, on the same worksheet. The worksheet view is "Page Break Preview" with a custom zoom
|
| Web Query date parameters | 16 Sep 2004 20:13 GMT | 1 |
I have numerous individual web queries maintained in spreadsheets that I need to update bi-monthly. It works fine except that each time the month changes I have to go in and revise the date for the query paramaters to coincide with that in of the
|
| a function which enters current cell address into a formula?? | 16 Sep 2004 20:08 GMT | 4 |
I'm trying to make a formula which adds numbers from the same cel address (i.e. column letter and row number) from various worksheets This same type of formula will be used over 200 times but each time th cell address will change. My question is: is there some function whic
|
| keyboard shortcut for charting | 16 Sep 2004 19:51 GMT | 2 |
I know there is a shortcut to create a chart but I can't remember what it is? ANyone know? clair
|
| Exporting Excel Spreadsheet to a Space Delimited File | 16 Sep 2004 19:48 GMT | 2 |
I am trying to export a file from Excel to a space delimited text forma (.prn), and the spreadsheet contains about 530 characters per row. Whe I try to save this as a .prn file, it wraps all data past the 240t character, to the next line.
|
| Reminder program linked to Excel? | 16 Sep 2004 19:10 GMT | 3 |
I was wondering if there is a program that will link to excel that would prompt me to phone a client based on a cell with a specfic date? Thanks, Mike
|
| Code won't work if activesheet is a Chart Sheet | 16 Sep 2004 15:26 GMT | 3 |
I have an issue with an XL macro that will work only if the activesheet is not a chartsheet. I've posted a question on the OzGrid.com ( Please see thread at following link ) http://ozgrid.com/forum/showthread.php?t=23972&page=2&pp=10
|