|
VBA Error "Type Mismatch"
I've run this many times with no errors. Yet now i'm getting a type mismatch
error. Could it be because I've already run this once in this particular
document? Or is it something else. I added a colum to the worksheet, as
well as a lookup table. Would the lookup table be screwing me up? I've
valued my results so there should be no formulas left. Any help would be
appreciated!
Je...
|
5 |
29.08.2006 22:39:59 |
|
|
Drop down list to select worksheet
What I need to do is have a drop down list with various suppliers making up
the names in the drop down list. The workbook has several worksheets - one
each for each supplier.
What I would like to know is how do I make a selection of a particular
supplier from the drop down box which then takes me to the worksheet
represented by that supplier?
Any help most appreciated.
Cheers
M...
|
6 |
29.08.2006 21:54:09 |
|
|
sum and combine?
I have a table that I need to combine the totals and items.
red 4
red 9
red 5
blu 9
blu 2
gre 8
gre 3
Can excel combine and add the totals to look like this?
red 18
blu 11
gre 11 ...
|
8 |
29.08.2006 19:44:19 |
|
|
Accessing Cubes -- Pivot Tables vs. Cube Analysis Add-In?
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C6CAA4.EBE3A5D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I am accessing some cubes created with Analysis Services on SQL 2005.=20
Wondering if anyone has a link to a website or document that can detail =
the advantages (if any) of using the Cube Analysis a...
|
2 |
29.08.2006 19:25:01 |
|
|
Using DateAdd function with cell values
Both F7 and H7 contain a date yet this sub does not execute the
statements after Then.................Please help.
Sub GetAmOrDep()
Dim TestDate As Date
TestDate = DateAdd("m", Range("F7").Value, Range("H7").Value)
If TestDate < Range("I7").Value Then
Range("K7").Select
Selection.Copy
Range("M7").Select
ActiveSheet.Paste
End If
End Sub
...
|
5 |
29.08.2006 19:06:55 |
|
|
Finding Min In Calculated Pivot Table Formula
I didn't have much luck on another list, so I thought I'd try this one.
Any thoughts on the below would be appreciated.
I have a pivot table with a calculated field for which the equation is
[Sum of Dollars / Count of Instances]. So in turn I'm rendering the
average cost for a list of items in a group. The table is set up such
that each column contains a week number and the rows contain ...
|
1 |
29.08.2006 18:47:48 |
|
|
one text column to several columns/table ?
Occasionally I would like to print the contents of a big folder onto one
sheet of paper. ( TO scribble make notes etc. ) Often it's an entire
folder so I type "dir /b > pix.txt". ( remember DOS ? ) That gets me all
the filenames in one file that I open with Excel - and of course all the
data is in column A. Anyway in Excel to easily convert that into "as
many columns as it takes to p...
|
6 |
29.08.2006 16:50:53 |
|
|
Personal.xls not hidden in Excel 2007?
Hi,
When I open a spreadsheet in Excel 2007 my Personal.xls file opens too,
in a separate window. (I get a separate "tab" in my task bar.)
If I remember correctly from Excel 2003 the Personal.xls was actually
hidden and didn't open, but the macros in it were made available to
open worksheets. In any case, that is the behavior I would like.
Is there a setting somewhere that makes the Pe...
|
7 |
29.08.2006 16:50:53 |
|
|
Track date row modified?
Hi - I'm trying to figure out how to track the date a row was last
changed in an excel spreadsheet. We use a simple sheet to track the
status of different projects, where each project is a row. I'd like to
have a column showing the date any changes were last made to that row.
Can't seem to figure out how to do that - any suggestions?
Thanks,
Michael
...
|
2 |
29.08.2006 15:34:03 |
|
|
Links in a template?
I have a excel template that has a link to a txt file in the same
folder.
I would like this link to stay 'local' when the template is 'saved as' a
XLS file to a different location, but it always refers back to the
directory of the original template. Is there a way around this?
And is there a way to define a link in the template by the value in a
cell?
Say when my data is impor...
|
1 |
29.08.2006 11:01:52 |
|
|
Sort-function of AutoFilter doesn't work, when sheet is protected
Hi there,
I have a sheet with some columns of locked cells and an AutoFilter in
the header-line of the sheet. I have to protect the worksheet to
protect the formulas in some cells.
When protecting, I choose to allow all users to use AutoFilter and Sort
function.
However, when I open the sheet in protected mode, I can use the
AutoFilter-function to filter the data, but then cannot so...
|
5 |
29.08.2006 07:54:25 |
|
|
Chart series display problem
At the end of my chart I always have a vertical line that is going to 0.
That is caused because the cells that the chart draw contains formulas. The
outcome of the formulas is space but the chart sees them as zeroes.
What I would like to do is the use somthing like the formula below using the
indirect function inside a series function so I can always know which is my
last cell to draw tha...
|
4 |
29.08.2006 07:47:31 |
|
|
Thanks a lot
Thank you sooo much, Ian. I don't know what should I do to solve this
matter.
Anyway, thanks
...
|
1 |
29.08.2006 01:17:22 |
|
|
data table too long to setup
Hi All
This company sells tickets to people who stays in hotels for activities
they organise.
I have already prepared tables to get data for sale sheet ie user will
enter ticket number,
Activity name,activity date,hotel name, client name ,room number,number
of people.
All other information will be picked up from pre-set tables.So far no
problem except
They sale nearly 40 different activ...
|
1 |
28.08.2006 22:24:39 |
|
|
Multiplication question
Hi,
I have a row of numbers that I need to multiply by a single constant and
then sum over.
I thought I could use a sumproduct formula like
SUMPRODUCT(D5:D20,$M$5:$M$5), but unfortunately this does not do the trick.
Can I do this without a UDF?
Thanks,
Schiz...
|
7 |
28.08.2006 21:59:54 |
|
|
Runtime error '424': Object Required
I keep getting error in the subject line. Can anyone help me debug this
code. Thanks
Sub CopyFixedAssetsformulas()
Dim startRange As Range
Dim rglast As Variant
Dim lastrange As Variant
Set startRange = Sheet20.Range("A5")
Set rglast = Sheet20.Range("A5").SpecialCells(xlCellTypeLastCell)
Set lastrange = Sheet20.Range("A5", "A" &
rglast.Row).Find("Summary", Look...
|
3 |
28.08.2006 20:56:37 |
|
|
show pivot table detail in same cell
I would like to create a report using following sample data in excel
ticket , monthly release ,
application
111-fix login bug , 2006-06 , ABC
112-improve logging , 2006-06 , ABC
113-enhance blah blah , 2006-07 , XYZ
114-fix performance issue , 2006-08 , ...
|
1 |
28.08.2006 20:54:27 |
|
|
just terrible excel calculating error, please confirm if you have same result
Hello!
I spent many hours trying to understand what's going wrong with one complex
financial worksheet. I found very, very strange Excel behaviour. Try to do
this:
1. Open new excel workbook
2. Type "99.9" (without ") in A1 cell
3. Type "3" in A2 cell
4. Type "=A1/A2" in A3 cell
5. Type "=(ROUND(A3,1)-A3)" in A4 cell
I have result in A4 which is NOT ZERO, and it's not possible res...
|
8 |
28.08.2006 19:08:22 |
|
|
Subtotal a calculated field in a pivot table
I'm creating a pivot table listing Accounts Receivable transactions by
customer. It includes both payments and invoices in the results.
Unfortunately both payments and invoices are listed as positive
numbers, so I can't just subtotal the "amount" column.
I've created a formula field in the pivot called "calcamt" that
contains an if statement. The if statement examines the transaction
typ...
|
3 |
28.08.2006 18:59:03 |
|
|
export worksheet data to access DB
I have a price list that utilizes several dropdown boxes (via data
validation) and vlookup values. when all is said and done, I end up with a
list with a customer name, phone number, and a varied combination of options
in various sections of the worksheet, but definately in nice linear rows. My
desire is to be able to develop some method, whether through VBA or macros to
collect each op...
|
3 |
28.08.2006 17:09:02 |
|
|
IF Function
Hi I will explain what I am trying to do.Two columns of football scores in
A1 and B1 they could be 0-0 1-1 1-0 0-1 etc I am trying to use the IF
statement to work out if they are say draw, score draw, home win, away win.
I am getting nowhere can you help please
Michael
--
All mail is Checked by TREND MICRO PC-cillin Anti-Virus system
(http://www.antivirus.com).
...
|
5 |
28.08.2006 16:29:46 |
|
|
Linking to files with a formula
In Excel 2003 what is the trick to linking to a closed work sheet using a
formula?
I'd like to put a list of file names in column A then use a formula to ling
to cells from those books.
Straight link works ='C:\My Docs\[File_1.xls]Sheet1'!X1
Formula does not ='C:\My Docs\[&A4&]Sheet1'!X1
Indirect will not work because I have too many books.
Grateful for any help on this one!
Thank...
|
4 |
28.08.2006 15:18:08 |
|
|
opening a lot of files
I have an installation of excel 2003 that for some reason is opening
all kinds of files when it opens. As far as I can tell it is opening
all visible files on the root of C drive at the moment.
Any ideas on what would cause this or how can I fix its?
...
|
4 |
28.08.2006 15:17:17 |
|
|
Comparing data within 2 lists
I have been asked to compare lists from my 2 main systems. They believe that
the information of them is not consistent. How would I compare the 2 lists in
Excel since there are over 30 thousand records on them. Information:
List 1 List 2
Building no. Color Building no. Color
Building 1 Blue ...
|
3 |
28.08.2006 15:01:19 |
|
|
Problem Viewing Pictures In Cells
Hi,
I have a bit of query I hope someone can help with.
I have a spreadsheet that I update on a regular basis which uses pictures,
flags of countries to be precise in, cells.
For some reason, when I opened the spreadsheet to update this today, the
data was there, but the pictures were not visible. It appears that the
pictures are still there as if I click on a cell, I can see the o...
|
4 |
28.08.2006 13:52:02 |