| Thread | Last Post | Replies |
|
| Macro help | 28 Aug 2007 02:30 GMT | 4 |
I have a table with thousand of row of data. The column consists of part# and operation, etc.... Within the data rows, there are multiple rows with same part#, but at a different operations in numerical 10 to 999. I would like to create a macro
|
| Disapprearing Zero | 28 Aug 2007 02:27 GMT | 6 |
Hello, If anyone can help. I am using a excel for filling out time sheets where I work and when I enter the start time of my job excel is kicking out a number. for example I need to input this 0830 when I hit enter or move to next cell it turns into this 830. Problem is that ...
|
| Automatic update formula when worksheet 1 move to another excel fi | 28 Aug 2007 02:19 GMT | 3 |
I have 25 worksheets on excel 1. I decided to shift the first 10 worksheet to another excel file (excel 2). But on excel 1, I have a summary page with formula from some of the worksheet file. Is any way that the summary page will update if I move the first 10 worksheet from excel ...
|
| Creating a button in excel that adds one to a cell | 28 Aug 2007 01:12 GMT | 2 |
I am creating an attendance list in excel and need to know how to create a button, that when clicked, adds on to the assigned cell. there will be five buttons for every name on the list. One for each school day of the week. Thanks for the help.
|
| Reference to an Outside Excel Document | 28 Aug 2007 00:44 GMT | 1 |
Is there a way to have the data in an excel document be linked to another excel document? For example, I want to keep track of my charges and deposits to various credit/debit cards. I'd like to have an excel document for each card. I'd
|
| Average function not returning expected result | 28 Aug 2007 00:36 GMT | 4 |
I have a column of 25 numbers that include zeros that total 74. I have applied the average function and rounded the result to two decimal places. ROUND(AVERAGE (number 1,number 2...),2). The result that I am receiving from excel is 2.64. When I use a calculator
|
| Access macros in Excel - populate results in spreadsheet | 28 Aug 2007 00:30 GMT | 3 |
I've got a macro in Access that runs two Append Queries to a table. I want the resulting table to populate an Excel worksheet - can I use the Import Data function in some way to do this? I already use it to Import some regular query results.
|
| Using variables within a formula in the same cell. | 28 Aug 2007 00:14 GMT | 5 |
How do I make a formula with a variable (ex. 4+x), and make is so when I type in a number into that cell it puts that number in as the variable? Is this even possible? Thanks for your help in advance cause this problem has taken way too much of my time already!
|
| Formula is being added automatically | 28 Aug 2007 00:07 GMT | 1 |
I have a spreadsheet that our office uses to calculate payroll hours. When different users open it up (it is a shared worksheet) some formulas will automatically copy. What would be causing this?
|
| how to convert the fraction to a percent | 28 Aug 2007 00:02 GMT | 1 |
how to convert the fraction to a percent plz
|
| Summing a Variable Number of Cells | 27 Aug 2007 23:43 GMT | 1 |
I have a spreadsheet that calculates values for each year out to a given date. If I want to know what the sum of some specific time period is and not necessarily the entire column, how would I instruct excel to only add a variable amount of rows on a specific column?
|
| VBA SaveAs Value | 27 Aug 2007 23:33 GMT | 4 |
I have a startup macro on one of my worksheets. It has the user input a batch number into cell a1, and then it saves the file as the batch number. The batch number is something like 01.ABC.255. When I try to run the macro listed below, the file saves as a .255 file instead of a ...
|
| Count column if heading exists | 27 Aug 2007 23:32 GMT | 4 |
Hi, I have a report that calculates passed, failed, and N/A results. These are also the titles of the columns. If one of these columns does not exist then the calculations fail. I would like to know if there is a way to only calculate these columns if they exist.
|
| Logically Calculating Multiple Fields | 27 Aug 2007 23:08 GMT | 5 |
I would like to see if someone can help me with this calculation. If cell E2 is 10% or above, we would like cell H2 to add one for each cells of A2, B2 and C2 that have a score of 6 or higher. Essentially:
|
| Help !!! Office 2007 "Rows to Repeat at top" how ???? | 27 Aug 2007 23:03 GMT | 1 |
in the older version of excel, you repeat rows on top from the "File and Page SetUp", in the newer version 2007 its not there, how do i do this ??? Any ideas ???
|