| Thread | Last Post | Replies |
|
| Thumbnail ? | 17 Mar 2005 01:19 GMT | 2 |
How can I change an Excel to thumbnail? Thanks in advance.
|
| If statement referring to a blank cell | 17 Mar 2005 01:04 GMT | 1 |
I want to put an if statement in code that will say something like If a1 is blank then blah blah blah end if
|
| macro to eliminate repeating account numbers | 17 Mar 2005 00:11 GMT | 2 |
I have report that shows customer account numbers and the date transactions occurred for that account. Some customers have more than one row on my spreadsheet because they have made more than one transaction. I only want to show the FIRST transaction each customer made and delete ...
|
| formula query | 17 Mar 2005 00:09 GMT | 2 |
I have a group of 52 "weekly" spreadsheets , each one is named after this week's start date in a prcise format e.g. 130305.xls. I want to create a cell within each weekly sheet which simply contains this weeks date. Obviously I could manually enter this data but I would prefer ...
|
| Large Pivot Tables | 16 Mar 2005 23:30 GMT | 3 |
I have a data source with 165000 rows that I would like to make into a Pivot Table, but it exceeds Excels 65K row limit. Any suggestions would be appreciated/.
|
| AutoFill Visible Cells with Months | 16 Mar 2005 23:14 GMT | 3 |
I would like to type Jan in A2 and AutoFill up to however far the selection goes. However, there are some rows that are hidden. I am not able to autofill the visible cells in the selection. What I have done is:
|
| graph change from line to bar | 16 Mar 2005 22:54 GMT | 1 |
I have a combined graph (lines and bars) I want to add some date series, but I want some series displayed in bars and others in lines How can I change the graph type of one data serie?
|
| $ format within if statement | 16 Mar 2005 22:32 GMT | 2 |
I am using Microsoft Excel 2000 for a financial spreadsheet. I want to compare two different financial computations and see which is higher for each row. My "if" statement looks like this:
|
| Question about protected templates | 16 Mar 2005 22:14 GMT | 6 |
I want to be able to insert a picture into an unprotected cell in an Excel worksheet that is protected. Can this be done?
|
| Link VBA - DLL (in C): how to send an array as an argument? | 16 Mar 2005 21:29 GMT | 2 |
I am working on an VBA application that needs to send an array as an argument to an external libray written in C. The library uses the array as a vector of parameters, and then returns a certain value. The link is working well with a single argument (a double, an integer,
|
| How to search for only protected files? | 16 Mar 2005 21:27 GMT | 3 |
At a company where an employee has recently left we need to find all workbooks that are password-protected. I don't see any built-in way to do this and I haven't had much luck searching usenet and the web either, with the exception of
|
| Macro problem | 16 Mar 2005 20:36 GMT | 2 |
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 3/16/2005 by jim
|
| In Excel, how do I create a one page doc, like the templates? | 16 Mar 2005 20:27 GMT | 1 |
How do I start with a 1 page doc? I want to do things like center a cell at the top.
|
| sumproduct in code | 16 Mar 2005 19:45 GMT | 2 |
I am using code to try and populate a table. The table looks like AA AB 1
|
| Data Validation - Also allow items not in list | 16 Mar 2005 18:22 GMT | 7 |
I want to use data validation to allow users to select the most common answers in a drop-down menu, but I also want them to be able to type in others that are not listed. I am sure the solution is easy I just can't seem to find in on the boards.
|