if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Can SUMPRODUCT be used for entire column?
This formula results in a numeric result:
but this formula results in a #NUM! result:
Which means I need to specify the length of the columns, which may grow over
time. Any way to do this for the entire column, without having to specify
the length of the column?
XL07 removed the limitation on array formulas (which SUMPRODUCT is, even
though it doesn't require CTRL-SHIFT-ENTER) and entire columns.
For pre-XL07, one can use
to get all but on...multiple email identities
HELP! My husband and I share the same computer and we
have our email come to our inbox through Microsoft
Outlook. However it is merging our accounts- how do we
seperate into 2 identities so we each get our own mail! It
is so frustrating! Please help!
Outlook does not use Identities - it uses profiles.
See this page for more information:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After s...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...CSliderCtrl Dynamic Orientation
Is it possible to change the orientation of a slider after creation? I
cannot figure anything out besides making a new window with a new slider.
Any help would be greatly appreciated.
I can change the slider control orientation using CWnd:ModifyStyle() but when
I proceed to adjust the dimensions of the CSliderCtrl using SetWindowPos the
slider vanishes even with a repaint. Any ideas?
> Is it possible to change the orientation of a slider after creation? I
> cannot figure anything out besides making a new window with a new slider.
>...Sorting on Column headers
I have a spreedsheet that someone else created and I need to take the
Column headers, which are in date form, and rearrange them in
chronological order. Can this be done without cutting and pasting? I
really need to save time with this project if possible.
Message posted from http://www.ExcelForum.com/
> I have a spreedsheet that someone else created and I need to take the
> Column headers, which are in date form, and rearrange them in
> chronological order. Can this be done without cutting and pasting? I
> really need to save time with this project if possib...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message
news:DA9FFF99-FC28-...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Configure Microsoft Dynamics CRM for Outlook
While trying to configure Ms CRM for outlook throws an error message HTTP
Status 401: Unauthorized.Can anyone put me out of this issue.
...Opening Multiple Web Links in a Column
I am very new to using web links in excel. A task I do very often is
open a list of different websites that are in various columns in an
excel spreadsheet. I am quite sure I am doing it the slowest way
possible, so I need some help please. Basically I have been clicking
on one link at a time. When I do this, the first website opens and
excel automatically minimizes, then I have to go re maximize excel and
then click the next web link and the same thing happens, etc... very
time consuming. I am wondering if there is a way, either through Excel
or whatever means necessary, to open all...Customize columns in 'Marketing List Members'
I can't figure out where one can customize the columns used within the
"marketing list" entitry when you click the 'marketing list members'
on the left side to show the members. I want to add some columns, like
Just read the Posting on the Microsoft CRM Team Blog.
<firstname.lastname@example.org> schrieb im Newsbeitrag
> I can't figure out where one can customize the columns used within the
>...China + Dynamics GP
We are opening a distribution center in China and was wondering if anyone
else is currently using Dynamics GP and any form of EDI process with China.
We are considering what would be the best way of handling. Due to security
risks, we are wary of allowing RDP/term serv access. So one idea was to give
them a laptop with GP/Sql Server/Integration Manager. Since they couldn't
connect to us they would have a separate database. This would then involve
exports and imports between the 2 company locations to a neutral site (such
as FTP). Not sure yet if we will be mirroring the datab...ANN: Optimizing the Performance of Microsoft Dynamics CRM 3.0 white paper
the White Paper "Optimizing the Performance of Microsoft Dynamics CRM
3=2E0" is now available:
...Character Length in a column
I have a column where every cell must have 14 characters.
Lets say have the name Angel. I need 9 more charcters. Next cell down
have the word cake. I need 10 more charcters.How do I automatciall
insert the spaces I need to have 14 charcters. HELP PLEASE!!!!! GOIN
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Do you care about what characters are added? I'l...Freeze the side column/top row & scroll others
what is the function to set (lock in or freeze) the first column and / or top
of a spreadsheet, so the words and numbers remain in the same place as you
scroll the other columns and rows.
(so you can add more columns..yet keep the main information in the first
In older versions of Excel, it is under Window.
In 2007 version of Excel, it is under View.
You first select a cell, then activate the command. Excel uses the selected
cell's upper left corner to define the freeze point.
Play with it. You can also Unfreeze panes that were fro...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".
=SUM(IF(A1:A15<>"",1/COUNTIF(A1:A...creating template for multiple emails
How or can one create an email template (same subject line
and message)for multiple emails (approx 100's)?
Needing to shorten the time it takes sending 100's of
individual emails (with the same subject line and same
message) to sales staff on a weekly (some times daily)
basis. Company does not want sales force using other
sales persons email addresses (they are contractors).
Try using a Distriburtion List, send one message, it goes to all of them, or
get the message ready, put your address in the TO: field, and put everyone
else in the BCC: field?? That way no one can see wher...multiple iterations of same query
Running Access 2003 on Vista.
I have a query that chooses 15 records at random. This works fine.
What I want to do is run the same query for approx 110 different users, each
with their own randomly selected 15 records. Obviously, I want to avoid
manually running the same query that many times. How can I get around this?
Post your query SQL.
Build a little, test a little.
> Running Access 2003 on Vista.
> I have a query that chooses 15 records at random. This works fine.
> What I want to do is run the same query fo...Question for Bob Phillips re Splitting Names from Cells
You gave the answers below for splitting names from cells:
Using these formulas on this example John A Doe results in John A an
Doe, is it possible to split it to show John / A / Doe in 3 separat
cells, I know I could use the formulas again on the John A result t
split them but I'd like to do it in 1 go
If possible could...calendar for multiple time zone users: all day events
Users in different time zones post absences and meetings to a shared company
calendar. When an all day event is scheduled in one time zone, it shows as
spanning two days for other time zone users. How do we make this work
For the others it does intrude on a second day.
> Users in different time zones post absences and meetings to a shared company
> calendar. When an all day event is scheduled in one time zone, it shows as
> spanning two days for other time zone users. How do we make this work
Until you upgrade to Outlook...Seperate jobs for multiple worksheets
Separate jobs are sent to printers when I select multiple worksheets... If I
print to PDF, multiple files are created. How can I avoid this?
...Change Domain Name on outgoing Emails
Our company just purchased another company with their own Exchange Server and
AD infrastrure. We want all users in this new facility to have Email
addresses with our Domain such as email@example.com instead of their current
Domain firstname.lastname@example.org. Until I migrate resources from their Forest into
our Forest I have created contacts to forward all Emails from the abc Domain
to the 123 Domain. When users reply or send Emails from the 123 Domain it
still has their email@example.com Email address which will cause confusion
with our customers and suppliers. How do I force their Emails to us..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"