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...Build Dynamic Query from Form
I am trying to build a dynamic Query from a Form.
I keep getting an error that reads ‘Object qryFilter already exists’
I suspect it has something to do with the string of dates being passed to
strDateCondition = "([Trades].[TDATE] Between [Forms]![SearchForm]![cboFrom]
I am trying to add a means for a user to Query by Customer and Trader AND
all records between two dates. This was working fine for Customer and
Trader; when I added in the code to filter by dates I started having
I know the SQL will be li...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...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...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...Update Query
Access 2003 XP SP2
I am having a problem with an update query.
Table is in a one-to-one relationship, referentail integrity and
cascading data are checked.
(The fileds I want to update are not in both tables)
Table name= payForward
Has 15 fields ie: ID, Name, MemID, Oct , Nov, Dec, etc
Oct-Sep fields are yes/no type
I want to "select" a field (Oct-Sep) via a query parameter and
repalce "yes" with "no".
Here is my query:
UPDATE payForward SET [Enter month]=No
The messages I get is
'operation must use an updateable query'
Wh...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...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...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...how to set up a query
I am using sql server 2005 express and have 3 tables
Dept_Id (primary key)
Employee_Id (primary key)
Dept_Id (foreign key with table1)
WorkSchedule_Id (primary key)
Employee_Id (foreing key with table 2)
Date_To_Work (date type)
I want to list all the Departments (Dept_Name) that do not have anyone
scheduled to work on a particular date (ie '1/20/2010' )
Any help would be appriciated.
Thanks in advance,
FROM Table1 AS D
WHERE NOT EXISTS(SELECT *
...Excel comparative query
I'm respectfully requesting assistance with the correct formula
to use for the following query:
I'd searching all of column A on spreadsheet 1 to see if a
value in column A of spreadsheet 2 is there, and placing
a result X (or another) next to (adjacent cell) the confirmed
value on spreadsheet 2.
Please help if you can.
see your answer in puclic.excel
> I'm respectfully requesting assistance with the correct formula
> to use for the following query:
> I'd searching all of column A on ...Currency Format Lost in Union Query
Thanks to John Spencer, I resolved one problem in my union query (Thank you,
John). But I have another problem. Some of my fields in my union query are
currencies and others percents. I see both formats are lost. I am sure it is
a union query problem, because when I ran an individual query, none of the
formats were lost. Is there any way I can keep currency and percent formats
without writing, FORMATCURRENCY, etc for each field?
What data types are these fields?
The field in a UNION query will normally take on the data type of the field
in the first SELECT. So, if ...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" <email@example.com> 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" <firstname.lastname@example.org> wrote in message
> With great difficulty I a...Getting all Sproc through one query
can anyone help in getting below information from all stored procedure
from one DB
we have 100 procedure in one DB of sql server 2005.instead if of
manully getting info for each procedure i want all below details in
one shot or one query
Procedure Name :
Input Parameter :
Output Parameter :
Called By :
Dependent tables :
Thanks in advance
...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
...Listbox Help (remove selected item)
This should be easy but I can not get it to work.
I have a simple listbox with Row Source Type property of value/list. It is
not mult select. I am using .additem to load the listbox and am not using
the itemdata property. I want to be able to select an item in the listbox,
click a button on the form to get the value in column 1 of the selected item,
then remove the selected item from the list box.
Thanks in advance for any help
"sk" <email@example.com> wrote in message
> This should b...Installation CRM 1.2 on SBS2003 SP1 fails, please help
At the end of my installation I get an error windows with;
Setup was unable to install Microsoft CRM Server
Setup was unable to provision your organisation
Setup was unable to create user settings.
Access is denied.
Active Directory is in native mode
I am installing as the administrator (domain admin)
security account for services in Local System account
Local System account and computer are added to the Pre Windows 2000 comp group
Thanks in advance for any support
Did you enter your organization name precisely the same way it appears on
your CRM 1.2 licenses?