How do you change the rows to columns and columns to rows.
Ok, I am stumped on how to do this?
I have a spreadsheed that has Dates in the A column and Data in the
row. I want to make is so, the data is in the A column and Dates ru
accross in the 1 column. How can I do this?
Sound easy, but I am stumped??? :eek
cc4digital's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2656
View this thread: http://www.excelforum.com/showthread.php?threadid=39843
Highlight your data and copy it into the clipboard. Move to an open
spot in the sprea...OnChange event
I want to let the end users change the color of the top and bottom dark blue
(or navy) borders of the Account form using a drop down that lists the colors
(red, yellow and blue) .So the OnChange event of the picklist should trigger
the change of the top and bottom dark blue colors to which ever color is
selected. However I dont know if this can be accomplished. I even dont know
if a stylesheet is used for that purpose, which one refers to these areas of
the form. Any help will be deeply appreciated. Thanks in advance!
...Changing mail file locations, correct method?
I've read instructions here for default location of Win Live Mail files and
how to change folders and drives. But what is the right method to use when
changing location of new incoming mail files...........and existing email
files and subject folders. Should I just gang copy all of the existing
folders from one disk to the other....before or after I change the location
for new incoming mail? I sure don't want to mess up my email any more after a
debacle when I upgraded to Win 7 from Vista! Help on method
If you wish to change the locati...How to temporarily change REPLY TO address in specific messages only (like in Outlook)?
I can't find out how to do this in OE, though Outlook has the option
to set a different REPLY TO address for a specific email, without
having to change the information globally in the account information
under TOOLS. Also, my email sniffer has an extra field labelled REPLY
TO where I just type in the different address the few times I need to
do that at any given moment>
Does anyone know how to do this in OE, though?
In OE, the only way is in Tools | Accounts...........
Imperial Beach, CA
"StargateFan&quo...Entering info in one field brings up info in another field
I have a problem where after I created this form, I entered data in one field
and for some reason, data in another field pops up automatically. The strange
thing about it is the field that pops up comes from another table. So the two
fields are unrelated.
By the way, the field where the information pops up has a Dlookup command
for another field in the form, that is also unrelated to the first field.
To give you a better understanding of this I will give you an example.
I have fields WorkDay, ClientID, and CompanyName. WorkDay is unrelated to
the others. ClientID is related to Compan...Filtering on text field
I am using an on Double Click event to filter based on the current value on
that field. It works when I use it on a number field:
Me.Filter = "[forMthYr]=" & Me![cbMthYr]
Me.FilterOn = True
but when I apply the same code (below) to a text field it does not work - I
get parameter boxes popping up.
Me.Filter = "[ITResource_LName]=" & Me![tbITResource_LName]
Me.FilterOn = True
Any help is appreciated.
Message posted via AccessMonster.com
It works on a numeric field because there are no d...Calculated fields in Pivot Tables
Is it possible to use an "if" formula when creating a calculated field?
I have an existing field in my pivot table called commissions and I
want to create a new field that will give me a 1 if for each row if
commissions are over 4 and a 0 if they are under 4. Is this possible?
What is the formula?
It seems ok
Try something like : =IF(Commissions>=4,1,0)
"lj" <email@example.com> wrote in message
> Is it possible to u...Outlook: Can't open JPEG files
I have Outlook 2000 an unable to open JPEG files. What
setting has to be changed to open these files?
...Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout
is perfect when printing to pdf (which is how the document will mostly be
used) but the layout changes if printing direct to our printer. Is there a
way that I can ONLY allow printing to pdf from this document?
You may consider using some VBA to achieve this.
One way is to use the Workbook_BeforePrint event and specify the pdf printer
in the PrintOut method, eg:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:"
Pl...why can't I get outlook to send when I'm emailing a webpage?
Hi. When I try to email a webpage to someone, Outlook immediately opens with
the email template but it is always missing the send button and there is no
option under actions to send it either. What is going on? Thanks!!!
If you tell us your Outlook version and Windows version, and exactly what
you're doing to send the page, then you'll have a better chance of getting a
response. The Internet Explorer version might also be helpful.
> Hi. When I try to email a webpage to someone, Outlook immediately...Unable to change password
We have some users in domain A, who now have exchange
accounts in domain B.
They will log on to domain A as usual, then when they open
outlook it prompts them for a logon to domain B. Works
Problem is that we gave them all a standard PW for domain
B so we could check their mail was working. We now want
them to change their passwords for domain B, so we
selected 'user must change PW at next logon' in the AD.
Sure enough they are prompted to change password when they
open outlook, but the password change is never accepted.
Can anyone help?
...Set field focus in a subroutine
In Access 2003 (Windows XP) I am passing the value of a field in a textbox on
a form to a subroutine to validate that the date value is within a range. If
the date is out of range I would like to set the focus of the field on the
form and display an error message. When I pass in the field to the
subroutine, I get a compile error "Invalid qualifier" when I try to set focus
to the date field. How can I set the focus to the field within the
subroutine. Here is the subrotuine code:
Public Sub CheckDates(date1 As Date)
If Not IsNull(date1) And date1 < [Forms]![frmMR...Select Rows dependant on certain field data
How can I select certain rows in a spreadsheet based upon the text foun
in one column? To explain: All rows have a column that contains tex
"immediate" or "ongoing" or "closed". How can I select only the row
that contain the word "immediate" in that column?
When I say select a mean select as in ready to 'copy' or 'cut' tha
data ready to be pasted elsewhere.
I know what I mean :confused
Maddy's Profile: http://www.excelforum.com/member.php?action=getinf...Can CRM 4.0 professional run on Windows SBS 2003?
CRM 3.0 shipped in two flavours: CRM 3.0 for Small Business Server,
and CRM 3.0 professional. Apparently, CRM 4.0 doesn't come in a "for
Small Business Server". Instead, it ships as "professional" and
Has anyone tried running CRM 4.0 on Windows Small Business Server
I'm running CRM 4.0 workgroup on SBS 2003 R2, didnt have any problems yet.
As long as you have your ReportServices right during installation, you should
> CRM 3.0 shipped in two flavours: CRM 3.0 for Smal...Percent Change
I'm using the formula (A2-A1)/A1 to determine the % change between two cells.
I have an instance where I need to subtract the value of two cells from the
current cell before determining the % change. I've come up with several
different ways to arrive at the actual changed value (e.g. A3-SUM(A1:A2) or
SUM(A3-A2-A1) ) which return the correct value but when I try to arrive at
the % change from the original amount by adding "/A1" to the formula I get an
error. Am I way off?
Could you post the end formula exactly as you typed it? It should work,
based on what you'...sort data without changing pattern
I have a worksheet where every other row has a 'pattern' in it to help make
it easier to read across the spreadsheet.
The problem I'm running into is as I add new rows at the bottom of the
spreadsheet and then resort them into their correct place, the patterns go
with the sort and now the patterns have to be redone again the get them back
to every other row.
This will happen if your patterns are manually applied. It would be
better to remove that manual shading and to apply background colours
using conditional formatting, the condition being if th...allow user to highlight field on form
I have a database which records info about disabled people. One form is used
to input comments about the the person and has several memo fields. The user
wants to be able to highlight a field if the information is important and
needs to be highlighted to other users of the system. I cannot use
conditional formatting because the decision to highlight the field is made by
the user depending on different circumstances.
Any help would be appreciated
On Mon, 3 May 2010 16:52:01 -0700, aussiebob wrote:
> I have a database which records info about disabled people. One form is used...Security Name
Hello - I have another problem that I could use help on. I have several
accounts with different brokerage houses that holds the same security but
with slightly different names. When I go to Update those accounts, I get
popups from Money asking if the name for the security is the same as another
security with a similar name. I say OK. But when it gets to the next
account I get the same popup to prompt me to put it back to the old name,
which gets annoying. To solve this problem, I could use 2 different names
for the same security but then my summaries would be based on 2 different
...Shape names question
I am currently trying to pimp a presentation with a couple of VBA
I am for instance importing png graphics and try to access those
through my scripts.
After playing with the macro recorder I was able to find out the name
of those shapes in order to set
properties or whatever. Slide108.Shapes("Picture 42").Visible =
Now my question: Is there for mainly readability reasons a way to
change those names?
I could'nt find yet where to change this, but I believe this must be
Thanks for any hint, I am using XP SP3 and Offic...publication designs in publisher
i am trying to create a flyer in publisher. basically, i
have about 7 or 8 different sheets, all with the same
content, but i want to have a different publication
design for each one, so i can show my boss variations.
however, when i try to change the publication design on
say, page 3, it changes it on page 1. i can't seem to
have 7 or 8 different sheets, all with different
publication designs. is this because it sees all these
sheets as one publication rather than 7 or 8? any help
would be much appreciated. thank you!
Read the HELP file how to turn off the Synchronisation.
...Where can I delete an old/incorrect email address?
I'm using Outlook 2003
So I have, say, Sandy in my contacts book.
Her email is SW@......
Later her email changes to SAW@......
I make the change in my contacts.
But when I'm creating a new email and I start to type "Sandy..." in the TO
field, it still finds the old "SW@..." address. Why?
How can I delete that old & incorrect address forever?
(Without starting from scratch and loosing all my old email?)
use arrow keys to highlight 'bad' address then hit delete btn
"jabadoodle" <firstname.lastname@example.org> wrote in message
n...problems with toolbar-can't access certan commands i.e.hyperlink
can't access some commands - was working fine - now some commands are in grey
- the commands disappeared from the pull down in the commands bar.
> can't access some commands - was working fine - now some commands are in grey
> - the commands disappeared from the pull down in the commands bar.
The hyperlink option may only appear when you are creating a Web
Publication in certain versions of Publisher.
Ed Bennett - MVP Microsoft Publisher
Trial version? You may have run out of time.
Some pulldowns only work when you are creating a ...Outlook 2003
We're on Exchange 2003 and have started rolling out Outlook 2003 in place of
In Outlook 2003 by default all folders come up grouped by day and with solid
lines between the messages. Everyone hates these "features" and has made a
point of telling me so. Yes, each individual folder can be changed back
through the user interface but that's a non-solution for 100 users that have
an average of 25 folders each plus the 50 or so public folders as well.
Is there any way to change this default behavior in Outlook 2003 so that all
folders come up without the solid lines...Select Names Dialog Box
Could someone help with the following?
I am using Access 2003 with outlook 2003 and all I need to do is open
outlook and for it to display the Select Names Dialog Box ( it would be nice
to open outlook if it was closed) no more than that. Hence I am now after
the code to go in the click event of the button.
Any examples of VBA code that will work within Access 2003 would be
The Select Names dialog box is programmable starting from Outlook
2007. You can't display it in Outlook 2003.
On Feb 5, 3:52=...Damn the accept/change downloaded transactions feature!!!
I recently upgraded from Money 2001 to Money 2004 and I HATE IT! My
favorite feature of Money was the ability to download all my
transactions electronically from my bank, and then decide how they
would be categorized and entered into my account register. Now it's
so much more complicated with this "Accept/Change" stuff!!!
I realize this has been around since Money 2002, but I'm just
experiencing this horror now. I HATE the way it just puts new
transactions right into your register! And what the heck does
"Accept" or "Change" mean anyway? Do they mean...