| Thread | Last Post | Replies |
|
| Varied product list | 01 Apr 2008 00:48 GMT | 4 |
I need to create a price list in Excel of our product line, but I need to be able to modify its contents to particular customer types. For example, our line includes frozen foods, candy, condiments, produce, non-food items, etc. Certain customers have no interest in our frozen ...
|
| Printing problem | 01 Apr 2008 00:09 GMT | 6 |
Let's say I have long list of data in columns A, B and C, which in the end makes it a long skinny table. I would like a print to "wrap" the table so that it can go 3 or 4 times from the top to the bottom of the page (we'll assume it's a landscape printing or an 11x17 sheet...), ...
|
| countif in VB | 31 Mar 2008 23:58 GMT | 1 |
Can this be done shorter, without using cell B1 Range("B1").Formula = "=COUNTIF(A:A,""*Stock*"")" Stock = Range("B1").Value Range("B1").Clear
|
| Excel 2000 PIvot Table Borders | 31 Mar 2008 23:07 GMT | 1 |
When I add borders to a Pivot Table, and then refresh the data, the borders disapper. Is there anyway to prevent that from happening? The "preserve formatting" checkbox under Options is active.
|
| how can i insert MY signature into an excel spreadsheet? | 31 Mar 2008 22:01 GMT | 1 |
I would like to be able to "sign" excel documents I create. How can I put in an authentic signature on the document?
|
| Calculating dates | 31 Mar 2008 21:40 GMT | 2 |
I am trying to track perfect attendance which is defined as a full year with no absences. I need to be able to distinguish between employees who acheive this for 1 year, 2 years, 3 years and so on. The data that we use is currently set up like this:
|
| How do I create a macro to remove path from hyperlink "address"? | 31 Mar 2008 18:48 GMT | 7 |
Excel 2003
 Signature May your footsteps be lost in the music of the forest.
|
| Row shading based on criteria | 31 Mar 2008 18:23 GMT | 6 |
I would like to have rows shaded only if a certain number on a row changes: So, if the data was like the following: 50772 JONE RON 355-FT-DR 50772 JONE RON 355-FT-DR
|
| Data Comparison | 31 Mar 2008 17:33 GMT | 1 |
Is there a way to compare 2 sheets of data and gets results that lists which records are duplicates and which records are unique? Will this also count the number of duplicate and unique records? Excel 2000
|
| Copying a Macro | 31 Mar 2008 17:31 GMT | 1 |
I have created a Macro and it is saved in my "Personal workbook". How can I copy this macro and/or save it somewhere that is it available for others at our company to use?
|
| Saving stripped down version of Excel Workbook | 31 Mar 2008 17:25 GMT | 1 |
How can I save an excel workbook with formaulas and links as values only workbook?
|
| Month-Year 'format' | 31 Mar 2008 17:20 GMT | 4 |
Hello. I'm setting up a results summary table that calculates from a detail tab. In the detail tab i'm capturing date of activity (where the user inputs a date) 3/31/08. On the summary tab i want to calculate results by month year.
|
| Massaging data to determine risk | 31 Mar 2008 17:14 GMT | 2 |
In range of data I need to find jthe largest numerical movement in one direction without (x) retrace. (x in this case being a specific whole number) Please help with a formula or direct me to where I could find this information.
|
| Filtering for Unique Records | 31 Mar 2008 16:42 GMT | 3 |
I'm working with a dataset of approx 2K records; each record has 15 fields. The uniqueness of each record is defined by 5 fields. Is there a way to filter for unique records given these conditions?? Thanks...
|
| Total each item's transactions | 31 Mar 2008 16:41 GMT | 2 |
I'm trying to create a document we can use to track some inventory. The first tab of the spreadsheet is simply a place where transactions are entered. There is a column for the part number, then a column for quantity, and then some other columns regarding other specifics.
|