| Thread | Last Post | Replies |
|
| insert page break when there is a change in the row value | 14 Jul 2006 19:20 GMT | 3 |
I am trying to find a formula to enter a page break when there is a change in the information in a column. For example, I have an address book in an excel spreadsheet and I want to insert a page break at the end of the a's, b's c's and so on.
|
| Copy content of cell to another depending on value of third cell (between worksheets) | 14 Jul 2006 19:17 GMT | 2 |
I have just begin to learn VBA for Excel and I need help. Can anyone give me code that copy content of cell in one worksheet to cell in other worksheet dependending of value in third cell. For example how to copy content of desired range of cells at sheet2 to some range in
|
| Format different worksheets automatically | 14 Jul 2006 19:08 GMT | 1 |
I have a Microsoft Access database that creates an Excel spreadsheet with multiple worksheets. Then mails it to certain people. This is on a daily basis. What I want is to make the worksheets of the file to be formatted a
|
| Search Multiple columns for criterion asterisk (*) and Return Numeric Label | 14 Jul 2006 18:56 GMT | 8 |
I would like to search multiple columns for criterion asterisk (*) and Return across a single Row Multiple Numeric Labels that MATCH the criterion on their respective Row. 1. The criterion is an asterisk * (multiplication sign) housed in cell A2
|
| Excell, print the tiles on all pages | 14 Jul 2006 18:37 GMT | 1 |
On Excell, How do I print the title row on all the pages
|
| PivotTable Question | 14 Jul 2006 18:28 GMT | 1 |
Hi everyone...is it possible to run a pivot a table on mulitple worksheets in a work book? I have two spreadsheets that are two large to place on one worksheet....but I need to consolidate the file in some reasonable way. Any help would be wonderful!
|
| Conditional Average Array with Dates, <blanks>, 0 | 14 Jul 2006 18:26 GMT | 7 |
I have the following table: A B C E F G H Dates Month Age Jan Feb Mar Apr
|
| Consolidate information / Summing | 14 Jul 2006 18:19 GMT | 2 |
Hi all, you've been so helpful I had to throw this at you. I have a table of data (see below). You'll note there are multiple identical items in the 1st and 2nd columns, the third being different
|
| SUMPRODUCTS | 14 Jul 2006 18:13 GMT | 4 |
I have been working on a spreadsheet where I need to count the number of occurrences dependent on two criteria. Here is my situation time blocks 0:22 2
|
| Automatically add date into a cell | 14 Jul 2006 17:48 GMT | 5 |
I am trying to get cell D2 on sheet 1 to automatically add date and time when a number is entered in any cell within a range a cells (C8:I59) on sheet 2. I am using Excel 2002 Can anyone please help
|
| Indicate the location file on the work sheet | 14 Jul 2006 17:00 GMT | 1 |
IHi I did a report and on this report I would like to indicate the way to get to this report for the other employee. I am working with excel Thanks
|
| "IF AND" statement | 14 Jul 2006 16:39 GMT | 2 |
I'm trying to get this formula to work. IF V55 equal 1 and V34 is less than or equal to 10 and V35 is less than or equal to 10 then I want a "1" or a "0" I get a "1" or a "False" with the formula below.
|
| How can I edit the year in a date field in Excel? | 14 Jul 2006 16:27 GMT | 2 |
I have column in Excel that is formated as for dates. I need to change just the year.
|
| CONCATENATE | 14 Jul 2006 16:14 GMT | 1 |
I have a spreadsheet with a list of skils in one column (SAP, HP, CRM, etc) and a list of names of people who have that specific skill in another column (Joe Bloggs, Jim Bloggs, James Bloggs etc). Each person often has more than one skill and so when you sort the name column ...
|
| Need formula to count spinoffs | 14 Jul 2006 16:07 GMT | 1 |
I have a sample of data I created and I'm trying to figure out how to count the total number of direct and indirect referrals there are for each member in a group. I have ... Column A = User #
|