Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin
and replace those values in a even larger list in a file Z an
highlight those values in Z
Message posted from http://www.ExcelForum.com
not really sure what you're trying to achieve. What do you
want to replace, etc. You may give an example (plain text -
no attachment please)
>I have a long list of numbers - values in a file X, and I
want to find
>and replace those values in a even larger list in a file
>highlight those values in Z.
>Message...Need a default email account for all users, need help.
I have a tablet PC running WinXP Tablet with Outlook 2003. This tablet
connect to our exchange server via VPN. How can I set it up so that
that logs onto their account can access one (the same) email account.
problem is that I dont know at this point all of the users however
using the tablet will use one generic email account. So how can I set
Outlook to default to this account so that no matter who logs on they
use this account?
...Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be
advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a
list of non-workdays, and defined the column of dates with the name "NWD".
What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb.
5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb.
5, and Feb. 6 and...DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have...
2003 2004 2005
Actual/Goal Actual/Goal Actual/Goal
Me 1009/1061 591/866 658/897
Comp. A 966/1012 633/811 624/808
Comp. B 699/744 450/593 480/607
Comp. C 957/1005 642/821 665/838
I wanto to show a bar for each competitor, for each year, so there will be 4
bars for each year. Each bar showing Actual performance & Performance Goal...please help with this query
Ost Ocity Dstate Dcity Carrier Price Rank Diff
A B C D X 1200 1 100
A B C D Y 1300 2 100
A B C D Z 1350 3 100
A B C D W 1789 4 100
A1 B1 C1 D1 X1 785 1
A1 B1 C1 D1 Y1 789 2
The rank for every carrier is based on the price . If rank1
is not a pariticular carrier(say if it is not X1 or
Y1 or Z1), then i want to calculate the difference be...Office 2010 Buying Question Assistance Needed
I've been looking through the MS Office 2010 web site to try to determine
what my new small company would require, but I can't find the information I
We for sure would need Office Pro Plus, but other than that I'm not sure. We
want to run it on our own server. We will initially have 3-5 people using it
and perhaps more later on. Would we need to purchase site licensing?
Unfortunately, our programmers are MS haters (I'm not) and I can't get any
assistance from them on this, but I have power of the pen. I would appreciate
any assistance I can get.
Th...can't find project or library
encounter this error : can't find project or library
when try to run a code which contains Calendar1.Value
Read the info on this page
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).
Regards Ron de Bruin
"Lynn" <firstname.lastname@example.org> wrot...Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that
link to a file on our server. I am needing to test to see if the file exists
and if it does, copy the file to a folder in my documents called
(CapturedFiles) and if it doesn't format the cell color to red. Can VBA do
this and if so how? Any help would be greatly appreciated.
Thanks in advance.
Fileserver or webserver ?
On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote:
> I am needing some major help. =A0I have a file with hyperlinks in column =
> l...Help please user not showing in 5.5 GAL but is in exchange 2003 GA
Up until today I have been bable to add users fine and their address would
appear in both the 5.5 GAL and the exchange 2003 GAL.
Is a single site with 2 5.5 servers and 1 exchange 2003 server.
When I add a new user now through users and computers and put the mailbox on
the new exchange 2003 server the user gets his email addresses and appears in
the GAL on the 2003 server but people connected the the old 5.5 servers
cannot see it.
When I open the 5.5 exchange admin tool again if connected to one of the old
5.5 server I cannot see the person I just created but when connected the the
20...VLookup #VALUE! error help needed to resolve
The following is the funcation I have:
=VLOOKUP(B10,'FA CC Summary Report 1141'!F$9:G$92,2,0)
I have all the columns formatted the same; as in the column that the
function is using to lookup is text and so is the column for this figure in
order to pull back the appropriate answer. I have keyed the data instead of
having links. I have replaced the final '0' with TRUE & FALSE then put it
back. I have formatted the columns for text and for numbers.
But I am getting the #VALUE! error in SOME of the cells NOT all of the
cells. I don't know what else to d...removing first exchange server in org
I am ready to move the first exchange 2k3 server from my organization. I
have followed the steps in article 822931 and finished them. I am just
noticing that one of the public folders - entitled system configuration - is
not covered in the instructions in 822931 and is set for replication between
the source(server being taken out)and destination server. Should i remove
the source server or does it matter. Thanks
...help with a sub
can anybody tell me why the following code fails at FormatConditions.Add
Private Sub CommandButton1_Click()
Dim Sh As Worksheet
Dim lngLastRow As Long
Set Sh = ActiveWorkbook.ActiveSheet
lngLastRow = Sh.Cells(Cells.Rows.Count, "A").End(xlUp).Row
Range("A4:E" & lngLastRow).Activate
Selection.FormatConditions(1).Interior.ColorIndex = 24
Traa Dy Liooar
You have an extra open paren just before MOD:
&qu...cdrom.sys corrupt in Win7
Yesterday Win7 decided to no longer show my 2 LiteOn DVDRW drives. I've
tried to re-install/repair the driver (6.1.7600.16385) and everytime I get
the same response = my current driver is good. BUT, then when I check with
Device Manager, it shows that the drives are not working. Can anyone help me
get a new cdrom.sys installed into the system32/drivers folder?
Booting up with the Win7 DVD will work. But I can't find the cdrom.sys on
the disk. No other repair options are there to get this fixed.
Help would certainly be appreciated. I don't want to have to start all o...Need to have more Columns available in advanced view
I know how to add columns in advanced view but i can't add all the
columns I'd like to add. I can choose more fields (attributs) as
search attributes than as result columns. Is there somewhere a switch
to turn a field (attribute) into not only beeing searchable but
selectable as a column in advanced search?
Example: "Invoice Product": Is there a way to make an advanced search
or view which delivers field (attributes) of "Invoice Product" as a
...Exchange 2003 SMTP QUIT
= = = = = = = = = = = = = = = = = = = = = = = = = = =
Problem is that OUR SERVER is sending QUIT-, instead of sending MAIL FROM:
MY Server open a SMTP connection
REMOTE Server says 220 ..
MY Server says EHLO to REMOTE Server
REMOTE Server says 250 ...
MY Server then say QUIT ! (instead of MAIL FROM ....)
We have::Exchange 2003 , cu SP1, pe Windows 2003..
Exchange has also IMF (spam filter from Microsoft) and Symantec
Mail Security for Exchange 4.5.
all PTR is installed and working OK.
The SMTP Server is workin OK a while, then it start opening a lot of
connections (7-10 /sec) t...Merging Projects ?
I created two dialog projects in a single workspace. My intent was to
merge them into a single project (the main dialog from one being called
from the other). The idea being that, by having both projects merged
into a single entity, the data transfer is possible between sections.
Although I took care to have resource.h use an independent set of
values, (even IDC_MAINFRAME vs IDC_MAINFRAME_II), I have been stymied by
the two independent resource (.rc) files (only one is allowed).
My current solution is to use ShellExecute(). Is there a way I can add
one dialog to the othe...Remove format link?
Is there a way to remove the format link between fields in Modifier? Help
just shows how to set it and the usual stuff doesn't seem to be working.
...Add Remove Message Inbox Headings
I have to do the ECDL (European Computer Driving License) Module 7
this week and I'm stuck on two points:
126.96.36.199 - Add/Remove Message Inbox Headings like: sender, subject,
date, received - How do I add or remove those headings in Outlook
Thanks for any help :)
...Add on for billing fixed fee projects?
My client has a need to bill fixed fee projects through CRM. The invoice
needs to display current billing, billed to date, and remaining billing
(against contract value) at a project task level. Anyone know of an add on
for project companies that can do this?
I am afraid there will be some specific add on, but many companies have doen
this customization, if you are interested for customization of such things
that is easy.
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
"Randy...I need help
Here is my problem. A couple of years ago I began playing
around with money. But I have come to the conclusion that
I really do like the services, but I now have a bunch of
acct. info that should have been input in a better manner.
I want to know how do I delete all of the old info so that
I can start fresh. I deleted that money program once and
reloaded it but it retrieved all of the old garbage that I
did not want.
Your help is greatly appreciated.
On Tue, 19 Aug 2003 20:58:14 -0700, "Matt" <firstname.lastname@example.org> wrote:
>Here is my problem. A c...Help styles
With great difficulty I am now creating documents with some styles.and
Now when I copy a table from another document into this document I get
and similar numbering all over the table.
How do I accomplish the copy without the numbering inside the table?
Try this: Select the table cells and press Ctrl+Shift+N. This (re-)applies
the Normal style to text.
Microsoft Word MVP
"afdmello" <email@example.com> wrote in message
> With great difficulty I a...Need help with cursor
I have a small GUI monitor application that doesn't have any
controls on it. Basically its a frame with a title, menu bar,
and client area. I dynamically size the frame for the contents
of the client. The client window contains some status information
about a service.
I've noticed that the cursor gets changed to inappropriate
values when the cursor is moved into the client area. For
instance, moving the cursor in from the side may leave the
cursor looking like the sideways-resize cursor.
My application is written in MS VC++ v6.0. What events
do I need to hook in...!!!!!!!!!!!!! HELP THE CHILDRENS !!!!!!!!!!!!!!!!!!!!!!!!!!4
...why do i need to iisret everytime I boot for crm to work ?
I have a crm sql and iis server on same box with win 2008 and its also a
Everytime I boot, i need to make a iisreset for crm to work. Anyone get this