handling links to external spreadsheets
Wed, 8 Oct 2008 21:10:47 -0700 (PDT)
I have a large number of links to cells in an external spreadsheet
that look like the following, where different cells on the source
spreadsheet are referenced:
for example, contents of cell Z5 on the destination spreadsheet:
='http://dummy_address.com/teams/projects/[data_analysis.xls]sheet1'!
C3 (source loc ...
|
Changing Font Colour of row depending on selection made in 1st col
Wed, 8 Oct 2008 20:05:01 -0700
I am currently trying to work out how to change the font colour of all cells
in the row, depending on the selection made from a list in the 1st column
(Col. A).
Column A is based on selecting from a List, with about half of the
selections already conditionally formatted to a certain colour.
My question is ...
|
linking spreadsheets to word
Wed, 8 Oct 2008 16:41:49 -0700
hi,
i've linked 1 spreadsheet to another spreadsheet in excel, but now i need to
link the spreadsheet to MS Word. therefore whenever i update the spreadsheet
in Excel, the MS Word one will also get updated
how would i do that?
thankyou very much ...
|
Excel automatically changing my formula
Wed, 8 Oct 2008 14:42:11 -0700 (PDT)
Hello,
This is a very annoying issue I have run in to and I don't know how to
work around it.
I have designed a sheet with 5 rows of blank cells followed by 2 rows
which sum up the previous 5. So the formulas work like this:
Cell | Formula
A1 | (empty)
A2 | (empty)
A3 | (empty)
A4 | (empty)
A5 | (empt ...
|
Marked cells more visible
Wed, 8 Oct 2008 14:09:16 -0700 (PDT)
When marking cells in 2007, is it possible to change the color to a
more visible one? ...
|
type date for next year
Wed, 8 Oct 2008 15:39:43 -0400
I'm entering dates for 2009 in my workbook and like to enter them quick.When
I type 10/29 then by default the date is returned as 10/29/2008.
How can I enter a date like 10/29 in a cell so that this cell automatically
sets it to 10/29/2009 and not 10/29/2008?
Thanks.
...
|
XP corrupted by trial version of 2007
Wed, 8 Oct 2008 12:16:12 -0700
Some time ago I downloaded a trial version of 2007. After the trial period
expired I removed the trial version from my computer. I subsequently had to
reinstall my version of XP and in Excel the grid lines print in a zigzag
pattern switching about every third line. I sent a message a few days ago,
but have ...
|
|
|
Macro Button
Wed, 8 Oct 2008 12:00:38 -0700 (PDT)
I used to have a button on a toolbar that I clicked and made a new
button in an excel worksheet that I could assign a macro to. It's not
on my toolbar anymore, and I have no idea what toolbar menu to look in
to find it. Anybody know? ...
|
copy new worksheet
Wed, 8 Oct 2008 11:06:07 -0700 (PDT)
I want to take a worksheet called "data" and make a copy to a closed
workwork called "all data". I tried
Worksheets("data").Copy after:=Workbooks("T:\me\the Data\all
Data").Worksheets(Sheet1)
It doesn't work...Do I have to first open the closed workbook inorder
to copy this worksheet over? Thanks ...
|
Combining Formulas
Wed, 08 Oct 2008 10:25:14 -0700
I have two columns that get data from two different formulas. The
reason I have two columns is becasue I couldn't figure out how to
combine the two formulas. I worked on it for a while, but I had to
give up and divide it in half.
I'll post the two formulas. Maybe someone can figure out an easy way
to combi ...
|
