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...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...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...single user mode
I need to be able to establish an exclusive connection to the database
and do a restore to it. Nobody, can be connected to that database
prior to the restore. Also, I need to be able to schedule it to run
on a daily basis.
I tried putting that db in a single user mode and then do the restored
in a transaction but I got the error that the restore command is not
allowed in the begin tran commit tran.
How can I accomplish that?
tolcis (email@example.com) writes:
> I need to be able to establish an exclusive connection to the database
> and do a restore to it. Nobody, c...Column comparing
I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
Check your earlier post.
Dave T wrote:
> I am trying to compare 2 columns of numbers so that I can identify and
> delete numbers no longer required. Can anyone help me find a formula for
> this please?
> Many thanks
...Hyper link one column to another
I would like to have my columns hyper link one another.
For example: Click on B2 would take you to N2, and vice-versa. Click
on C2 would take you to O2... and so on through column j linked to V.
Is this possible without having to make the link for each cell?
This is a timesheet template and the columns b though J are the hours
and N through V are the text comments for those hours. When I copy the
template to a
new sheet, there will be no data in any column. I would like to be
able to enter an amount or formula (=end-start) for time spent and then
be able to click on that cell and hyperlin...combining columns all the way down
I am trying to combine two columns of information in excel but th
concatenate function doesnt seem to work for it. It may just be m
ineptitude in excel but I just cant seem to figure this out.
I have 3 colums
Column A__________Column B___________Column C
But I cant seem to be able to make it so that column C has tree.jpg an
dog.gif and house.png
Is concatenate the wrong thing to use here? or am I making my formula
I have a total sheet that gets data from three different shift sheets (all
in the same workbook) for a monthly report. I have named ranges on each
shift sheet for each month's production data (S1M1, S1M2, S1M3, S2M1...)
where S1M1 =A2:AC147, S1M2 = A148:AC329, etc. The old formula
was:=SUMIF('SHIFT 1'!$L$1:$L$147,"BB",'SHIFT 1'!$T$1:$T$147). I'm stumped as
to what the new formula would be - how would I direct Excel to column L of
S1M1 to search for "BB", then add the contents of column T? The range
changes each month, and I tho...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...Look up column name, match rows (a/cnumber) & summing up....its confusing!
Here is what I'v been trying to do but..!
I'v 2 sets of data (data1 & data2) Column name may be sane/different in
each data set and same applies to acct_no.. I want to prepare a report
that combine product & accounts data show accumulatd result on another
Data 1 - upto Jan 2006
Acct. No Total Prod - A Prod - B Prod-C
1001 51 10 30 11
1002 47 15 20 12
1003 80 20 15 45
1004 64 25 16 23
Total 242 70 81 91
Data 2 - Feb 2006
Acct. No Total Prod - A Prod - B
1002 7 5 2
1004 16 10 6
1009 9 3 6
Total 32 18 14
Acct upto Jan'06 Prod - ...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...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...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...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...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...setting a column value in code for an updatable ViewGrid
Is there a way to set the value for a column in code when a ViewGrid row is
edited? I have a row-last-updated date that is a required audit field in
all our systems (required by data management). I don't really want the user
updating this field as it should always be system controlled. If I create
an editable ViewGrid tied to either an SqlDataSource or an ObjectDataSource,
the field seems to only be updatable by the user. I can set it the first
time by setting the DefaultValue in code but that has no effect after there
is an initial value in the column.
Do I need to co...Sent Items "To" Column won't show info
When I started using Outlook 2000, there was a column in the Sent Items folder for "From". I changed this column to "To". When I send an email and go look in the Sent folder, the column for "To" is blank. If I double-click on the sent email and close it again, the correct info is shown in the "To" column. How can I make this info appear without having to open the email?
...How can I use a form (Excel) to add a column of data to the right.
How can I use a form (Excel) to add a column of data to the right of a list?
It's a simple matter to add a column to the left of a list by writing a
macro that inserts a column and then pastes the values. However I want to
have the data pasted on the right of a list, if only so that I can easily run
a chart from it.
...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...