| Thread | Last Post | Replies |
|
| How can put numering or pullets in one cell in excel sheet | 30 Jun 2007 22:47 GMT | 2 |
How can put numering or pullets in one cell in excel sheet
|
| Copying Formula Problem | 30 Jun 2007 22:10 GMT | 4 |
suddenly, my formulas will not copy properly in excell. They retain the original cell amount - although display the proper line formula adjustment. This is happening on all of my excell spreadsheets. Someone suggested checking my cell format, which I have, and it is not text.
|
| Changing a text name within a cell based on file name | 30 Jun 2007 21:56 GMT | 1 |
I wonder if it is possible to change a cell contents based on the file name. For example I am using Excel file 2003 in my workbook sheet 1 in cell A2 it is populated with a text field - company name "Zenith Manufacturer" and in cell A3 has the company location text field "Tampa ...
|
| Dos command | 30 Jun 2007 16:31 GMT | 5 |
I used the "dir" command in dos to list all the folders and file in that directory. However, I want to go into a folder called "A" in the directory just listed. What is the command for this at the prompt?
|
| Two-Input table | 30 Jun 2007 16:23 GMT | 14 |
Allowence $au 2500 Exchange rate 75% Converted rate 1875 How do i do a two input table to calculate rates on a table
|
| Line Spacing | 30 Jun 2007 15:40 GMT | 5 |
I have a user that has a problem with line spacing that I cannot figure out. She has an Excel document that is emailed to her, and every so often, she has a line spacing that is about twice the size of the rest of the spacing in the document. I have tried to resize, but it ...
|
| IF statements | 30 Jun 2007 14:54 GMT | 9 |
In column A there are either values of "JR.", "CPA", "MD", or nothing. Can I create an IF statement that says if there is a text value in the cell put parentheses around that value and if there is nothing in the cell do nothing? Any help would be appreciated
|
| Importing a CSV File and using a Conditional Statement and Row delete? | 30 Jun 2007 14:48 GMT | 1 |
Hello Group, First off, this group is really helpful for us "newbies" attempting to do some calculations. A big kudo's for your monitoring this group. Question 1:
|
| Sheet Tab | 30 Jun 2007 14:37 GMT | 2 |
How can I put the sheet tab name into a cell (same sheet)? Thanks Peter
|
| Excel 2003 Pivot Tables / Running Totals | 30 Jun 2007 08:07 GMT | 1 |
I have a dataset of expenditures for a project consisting of a date and an amount. I want to produce a graph that shows spending per month, and a cumulative total across the project -- which extends for multiple years (3, to be exact).
|
| Importing data from text file without overwriting certain cells | 30 Jun 2007 06:19 GMT | 1 |
I have a VBScript that writes Active Directory computer infromation to a text file. Excel imports the data from this text file and I build charts reflecting the status of these machines. I'm trying to monitor the progress of a migration from one domain to
|
| Macro Help | 30 Jun 2007 05:01 GMT | 3 |
I have recorded a macro in excel and would now like to modify it but i could use some help. The first element of the macro is: - Range("A1:A2651").Select
|
| Unlock File | 30 Jun 2007 04:58 GMT | 3 |
Using Microsoft Excel 2003. New to Excel. Tried to open file. Error msg came back that reads "????.xlr is locked for editing." Do not how it got locked. How can I unlock file. Thanks in advance.
|
| counting empty cells in a column. | 29 Jun 2007 22:45 GMT | 5 |
Office Excel 2007 I have a file with two sheets Addresses and Summary. In a cell on the Summary sheet, I want to count the number of blank cells in Column B on the Addresses sheet that contains a Heading row.
|
| Excel 2007 Column Row Headings in formulas | 29 Jun 2007 22:40 GMT | 1 |
In earlier versions of Excel, even if they weren't explicitly named I could use column or row headings to create a formula. For example, if Mon, Tue, Wed appeared in B1:D1 and various expenses appeared in A2:A5 (ex: wages, mortgage, etc.) I could type Mon Wages in a cell and Excel
|