When Excel 2007 opens a xls file all links are changed
Sun, 5 Oct 2008 15:07:17 -0700 (PDT)
In my work environment we have one user who has just moved to Excel
2007 while everyone else is still using Excel 2003. When this person
opens a 2003 .xls file that contains hyperlinks, all the hyperlinks,
on all tabs, are changed. The following string is inserted into the
front of the hyperlink string replacing ...
|
Highlight intersection in a table using conditional formatting
Sun, 5 Oct 2008 07:43:02 -0700
I used the index-match function to return a value from a source table (see
below). Now I want to highlight that specific value from the source table
using conditional formatting.
Here's the Source Table:
A B C D
1 5.5 6.4 7.2 8.1
2 3.5 7.8 6.4 5.5
3 6.7 7.2 1.1 ...
|
Class
Sun, 05 Oct 2008 13:58:26 +0100
The following data is pasted into a worksheet in cell A3. Two examples
are listed below. Would it be possible to parse the data so that only
the digit in brackets is displayed in cell D2? The number in brackets
ranges from 1-7.
5:30 Nottingham 1 Oct 2008 Amateur Handicap (Class 5) 1m2f
16 Run ...
|
Top 10 Things To Look For In A Web Host
Sun, 5 Oct 2008 04:30:57 -0700 (PDT)
Top 10 Things To Look For In A Web Host
http://hosting-top10.blogspot.com/2008/07/top-10-things-to-look-for-in-web-host.html
5 Tips To Choose A Domain Name For An Internet Business
http://hosting-top10.blogspot.com/2008/07/5-tips-to-choose-domain-name-for.html
Domain Name Registration - Investments That Reap B ...
|
VBA Access export help
Sun, 5 Oct 2008 03:59:10 -0700 (PDT)
This is the code I am using to export a query from Access.
Dim db As DAO.Database
Dim rs As DAO.Recordset
'Set db = DAO.DBEngine.Workspaces(0).OpenDatabase( _
"C:\database.mdb")
Set db = CurrentDb
'This is a crosstab of all units by Unit Type vs. Failure Category
Set rs = db.OpenRecordset("qryPA_Cross_1", d ...
|
Sorting multiple time data based on time value on column A
Sun, 5 Oct 2008 03:00:17 -0700 (PDT)
Review the attachment. You'll see 2 sets of data, "What I have" and
"What I want". Of course, this is only a sample data, my actual data
sheet has over 10,000 rows and 25 columns.
The basic idea is to have some sort of script or formula where all the
time match in 1 row, yet the value stays the with time durin ...
|
How to refer to "self"?
Sat, 4 Oct 2008 23:21:37 -0700 (PDT)
Hello,
This is a simple question, but I have searched high and low and didn't
find the answer. I think I am not thinking about the problem in the
right way.
I have a set of rows with data on each row. I would like to put a
checkbox on each row at the beginining, and when the user clicks on a
row's checkbox ...
|
|
|
amortization
Sat, 4 Oct 2008 16:24:26 -0700 (PDT)
What are the benefit(s) of creating an amortization schedule in MS
Excel 07? ...
|
what function should i use
Sat, 4 Oct 2008 14:23:01 -0700 (PDT)
What function in excel 07 should be used to calculate the present
value of a loan or investment? ...
|
Excel 2007 question
Sat, 4 Oct 2008 09:47:35 -0700 (PDT)
How do you make row one appear the same on each worksheet in a
workbook? and how can you add a column and have it appear on all the
sheets? ...
|
