| Thread | Last Post | Replies |
|
| Using a macro that includes 2 worksheets | 24 Aug 2007 22:51 GMT | 3 |
Last night, my computer was upgraded to Windows XP. I found that macros I had recorded were no longer visible. The one I used most often was rather simple, so I just re-recorded it...it involves copying some data from a CSV file into an Excel spreadsheet. Before the upgrade, it ...
|
| Hard reference in a macro | 24 Aug 2007 22:24 GMT | 1 |
How can I keep my macro from using a hard reference to a particular run of a csv file that the macro exports into another worksheet? Each time I run the csv file (e.g. to tweak the macro, or just to test the macro to see if it's working), the
|
| Lookup | 24 Aug 2007 22:21 GMT | 1 |
I am trying to extract number (%) from a table using “lookup” however the first column to be used is made up of a range versus merely sequential numbers e.g. 0 >=70, >70<=80, >80<=90 and so on and then the row used is similar e.g. 0 >= 300000, >300000 <=400000, >400000 <=500000 ...
|
| search or find, and extract? | 24 Aug 2007 22:20 GMT | 1 |
I need help using Excel 2007. I have 10 trucks driving for me. Each truck will be driving for several of our customers. In one workbook, I have a seperate worksheet for each truck. That look something like this:
|
| Worksheet to new file | 24 Aug 2007 22:12 GMT | 2 |
I have more than 100 worksheet in a sheet and i want to save this worksheet as workbook at once. I can do I one by one. Please help me on this. Jai
|
| excel - formula to copy the cell contents and colour. Possible? | 24 Aug 2007 22:05 GMT | 3 |
does a formula exist so if i colour a cell on page one the contents, including the colour, will be instantly copied onto page 2
|
| Protection Reminder | 24 Aug 2007 21:04 GMT | 8 |
I have used a combination of locking certain cells and then protecting worksheet in order to prevent accidentally overwriting cells with formulae in them. This works fine for what I want but occasionally I need to change a formula so have to unprotect the sheet. Again, no problem ...
|
| Want to divide a number into groups of thousands | 24 Aug 2007 20:54 GMT | 3 |
I have a number, say 3,450, that I want to subdivide into groups of 1,000 like this: 1000 1000
|
| Solver Macro | 24 Aug 2007 20:54 GMT | 2 |
I want to create a macro that automatically runs solver when a button is pushed. I went ahead and recorded it, however every time I run it a dialogue box pops up asking me if I want to keep the solver solution. I always want to keep the solution and I don't want to have to hit ...
|
| Referring to Ranges in Change-Event Macro? | 24 Aug 2007 20:12 GMT | 4 |
I stole the bulk of the following code from one of Dave Peterson's many helpful postings on this site. I have a number of named lists on the sheet called "Feed Data." The lists are named "list1," list2," list3," etc. Each one is defined with an OFFSET function.
|
| How To Format Row Column Intersection | 24 Aug 2007 19:50 GMT | 3 |
Hello group. I have something I've been working on for some time and I'm stuck. Let me describe the situation. I track my fitness in a spreadsheet. One measure of fitness is the waist / hip ratio. This is waist divided by hip. I have a range
|
| Loan calculator with extra payments | 24 Aug 2007 19:38 GMT | 2 |
using the Loan Calculator template in Excel, I am trying to calculate loan payments with optional extra payments, over 5 years. However, every time I input the optional extra payments, Excel shortens the loan term instead of reducing the monthly payment amount (which is what I ...
|
| link 2 pgs. from 2 workbooks, getting 1st line only ? | 24 Aug 2007 19:32 GMT | 6 |
EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get cell A1 to come to the destination workbook. Help. Ema
|
| Using Now() in a Function | 24 Aug 2007 19:30 GMT | 2 |
I am using the Now() function within a function, to enter a timestamp as a spreadsheet is populated. Here's the function: =IF(AND(LEN(D63)<>0,MOD(B62,12)=0),NOW(),"") The function works fine, however, the timestamp continues to update,
|
| Excel 03 to Excel 07 | 24 Aug 2007 19:21 GMT | 2 |
Could anyone help me? I am taking and Excel 07 class at my college, but the computer that I use has Excel 03 (and also is not capable of downloading any new software or trial versions). If I do spreadsheets in Exel 03, will it convert correctly to 07 and vice versa?
|