| Thread | Last Post | Replies |
|
| how to transfer data from sheet to sheet with new range? | 20 Aug 2007 18:36 GMT | 6 |
Greeting I have a work book with two sheets. Sheet 1 is for entering data with range from a1to d1. in sheet 2, I need the range in sheet 1 to be transferred to a1:d1. What I want to do is when entering data in sheet 1, the data transfer
|
| Help | 20 Aug 2007 18:24 GMT | 7 |
I have just upgraded Excel from 2000 to 2003, when I go to help, I find I can only get online help, not the index, answers and table of contents I had on the older version of excel. Is this standard for excel 2003 or am I missings some element that I need to add.
|
| Date time format question please | 20 Aug 2007 18:00 GMT | 7 |
Can anyone please help me with the following formating question? A B C D 3/27/2007 11 49 3/27/2007 11:49 I inherited a spreadsheet that has the hour and minute columns B&C formated
|
| Constraining Constants w Regression | 20 Aug 2007 17:54 GMT | 2 |
It seems Excel presents two options for working with regression constants in Excel: -Excel sets the constant -Constant = zero
|
| What is this symbol and how do I get rid of it. | 20 Aug 2007 17:26 GMT | 3 |
I'm trying to seperate 2 differant names but stubborn excel keeps combining them with this symbol Im' guessing. I will enter Lindab (alt + enter)
|
| Macros Causing Workbook to Run Very Slow | 20 Aug 2007 17:14 GMT | 6 |
I have a large workbook with many buttons that run different macros. Mostly these macros copy and paste infomation for backup, analysis, and later use. I recently added a new feature that forced me to add many more of these functions, and now when I push a button, the workbook ...
|
| Run Vlookup in each cell? | 20 Aug 2007 17:10 GMT | 1 |
All - I have a massive spreadsheet with multiple columns that tries to look up data on other tabs using Vlookup. Problem is that when I try to run it, Excel locks up due to the massive amount of data its trying to
|
| Help with combining 2 formulas | 20 Aug 2007 17:05 GMT | 5 |
I would like to combine the following 2 formulas into 1 formula, yet I can't seem to find the correct way to do it, if it is possible. =SUMIF(Invoices!$J:$J,"="&(TEXT(E1,"mmmmmmmmm-yyyy")),Invoices!F2:F2000) =SUMIF(Invoices!A2:A2000,"="&(TEXT(A21,"00000000")),Invoices!F2:F2000)
|
| Macro project incl dcount, vlookup, etc?? help required | 20 Aug 2007 16:40 GMT | 5 |
I need help with using Excel to do a trend analysis of daily faults and report the totals on a daily, weekly, monthly and finally yearly basis. First some background: I receive a table daily consisting of 25 columns, a variable amount of rows
|
| Deleted navigation borders | 20 Aug 2007 16:36 GMT | 1 |
I messed up big time trying to import my web page from my Desktop to my laptop so I could do remote publishing. I have no idea what I did and now my web site is missing all the borders on the left side dso you can navigate to my
|
| Corresponding Cells With Dates | 20 Aug 2007 16:18 GMT | 1 |
I have a worksheet in which I have a row with number 1-12 to represent months. I a column which contains dates of termination in "mm/dd/yy" format. I am trying to create a formula which looks at the month within the date of the termination column and corresponds that with
|
| Finally works, but only for ME...! | 20 Aug 2007 16:06 GMT | 3 |
Last week I inundated this board with questions about the IF command, and linking to a table in another worksheet. Well, I worked out all the bugs and now the sheet looks and acts just fine!
|
| putting one name under another on a cell | 20 Aug 2007 15:04 GMT | 2 |
Easy question for most of you I know but... I need to know. If there are four names in a cell I would like to make them one under another. So, instead of: Matthew, Mark, Luke, John
|
| How do I return different values in single cell? | 20 Aug 2007 14:58 GMT | 3 |
This is the general idea of what I need to do; A1 = "A" if B1 > 0 BUT A1 = "B" if B1 > 0, AND B2 = "YES"
|
| Excel 2007 doesn't open to full size | 20 Aug 2007 14:55 GMT | 1 |
Well, it does much of the time, but every so often it does not. I like working with the worksheet full size. Sometimes I'll minimize the size to allow two different things to be viewed at once, but I always click the full size icon in the upper right before I save and close ...
|