Change background color of query results from access in worksheet
Fri, 23 Apr 2010 10:06:05 -0700
Hi,
I have Excel 2007 and selected Date => From Access and then navigated to an
Access DB and selected a query. I chose "Table" view. The query results now
appear in my worksheet which is great. However, I want to change the
background. Right now it alternatives by row between a light blue and a
darker ...
|
I have a simple help! thank you.
Fri, 23 Apr 2010 05:51:48 -0700 (PDT)
I have a simple help!
Thanks for your attention.
For example,
I have an "A" table, there was a formula inside and it'd show the
calculated result.
than
I need a "B" table to show the "A"' table's formula automatically.
(not the result)
How can I do?
thanks you. ...
|
In cell dropdown
Fri, 23 Apr 2010 04:55:29 -0700
That was a great tip. Thanks
Max wrote:
Do hope it worked ok for you, as it did on this other occasion for another
04-Mar-08
Do hope it worked ok for you, as it did on this other occasion for another
OP:
http://tinyurl.com/3bf2qu
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
...
|
spontaneous change of formatting
Thu, 22 Apr 2010 23:29:13 -0700 (PDT)
Hello,
In the company where I work we are currently experiencing a strange
problem.
What happens is that randomly and spontaneously, the formatting of the
spreadsheets we use gets changed. Say numbers formatted like dates and
vice versa for example.
This has never happened in the past, and it is something ...
|
Replace Columns
Thu, 22 Apr 2010 16:39:07 -0700 (PDT)
Hi,
I need some help. I need to replace an unsorted, unfiltered column
from one worksheet with a column from a second worksheet. My problem
is that I need to keep the rest of the columns in the worksheet
exactly the same. Is there a way I can link, group, or associate (not
sure of the precise word) two or mor ...
|
How do you kill "e-mail message-send" mode in Excel?
Thu, 22 Apr 2010 12:22:16 -0700 (PDT)
I must've accidentally typed a key combo to "Send" my workbook to
someone.
The upper third of my Excel 2002 SP3 screen is now an Outlook-style
app, with e-mail toolbar, send fields, etc. (all embedded inside
Excel).
How do you kill this unwanted view and return to a normal Excel
screen?
What I especiall ...
|
Paste a range of cells in the body of an email
Thu, 22 Apr 2010 11:48:07 -0700
I have been trying to get the code to work for copying a range of cells and
pasting it into the body of an email
I am using excel 2007 and Lotus Notes 7.0.2
My current code works kinda sorta.
It will copy and paste the text into the body of an email.
But it does not open a new email it replys to a email th ...
|
|
|
copy down
Thu, 22 Apr 2010 11:40:57 -0700
How can I prevent this?
Say column C2 has a number in it. Then I copy down and get same number as
desired.
BUT
If I copy the entire line down the number in C2 increases by one on each
line. Nothing in any formula increases the number in C by design.
TIA
SG
...
|
Query Outlook contacts folder from excel
Thu, 22 Apr 2010 09:09:03 -0700 (PDT)
Hi guys,
I've been doing some research, and i'm not finding or more so
understanding what i need to do. I'm not great with VBA, but am able
to cut and paste quite well :)
I've search the groups and found a couple threads but some links
inside the threads don't work anymore, so i'm sort of stuck.
I'm try ...
|
Chart Data Changes Data Type
Thu, 22 Apr 2010 08:12:21 -0400
Using Excel 2007, I have a line chart in Workbook A that is built from data
in Workbook B. The X axis contains dates. When viewing the chart in Workbook
A the dates a properly formatted when I have Workbook B open. However, when
I close Workbook B the dates change to numbers. When I open Workbook B the
numbe ...
|