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...Cannot move emails between folders
I am the Administrator on my home machine. If I try to move an email from
the Inbox to another folder I am told 'I don't have permission, check the
folder properties for permission' There is nothing in the folder properties
about permissions. This has only recently started happening. XP Home and
Outlook XP with all updates.
...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...I deleted my Public Folder under IIS By Mistake
I have deleted my Public Folder Virtual Folder in the IIS Manager by Mistake
How can I re-create this so that users can use the Public Folders through OWA again
You have a back up strategy every night right? If so copy it from the back up, if not, you need to have all of yoru databases log files.
...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...Hyperlnk to a cd-rom folder
How but a exel file that has hyper links to the folders on that cd rom with out naming a drive letter since everyone has a different drive letter for their cd rom???
The excel workbook is stored on that same CD?
If yes, this worked ok for me in xl2002 and using my harddrive (not CDROM).
(just the backslash)
Then I could insert hyperlinks via Insert|Hyperlink and just leave the drive
If the workbook is not on the same cd, you could have a file on the cd to look
for, search the CDdrives and determine the drive letter. Then have your mac...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Autosave mail sent from delegated mailbox
I'd like to autosave all mail sent from User Xs mailbox in his inbox. His
mailbox inbox is available to three different users who all have it added to
their Exchange account.
This way I'm able to auto-create readable conversations in his inbox and all
users can see which mail have been replied to from this mailbox and what the
You would have to write an event sink.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Kristofer" <Kristofer@discussions.microsoft.com> wrote in message
news:DA61E72C-9405-4BF...tasks entered in taskpad don't appear in task folder
All of the tasks that I have entered via the taskpad do not appear in
the task folder, what am I doing wrong or do I have the wrong
What view are you using on your Tasks folder?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
"John Keith" <email@example.com> wrote in message =
| All of the tasks that I have...List folders to file
Does anyone have a macro that would list all the folders (with path) and
subfolders to an excel sheet but not the files?
There's a function called CELL() that should return your filename (or
any of a number of parameters) but I can't get it to work properly on
my machine, so I can't make it work for you. The syntax is
=CELL("filename") which ought to return the path and filename of the
current file, and which you could then trim down to show just the path.
Can anyone provide some guidance here?
If it isn't working for you, it pro...Outlook xp Offline folders vs O2k3 Cached Exchange mode
I recently upgraded a group of executives from Outlook XP
to Outlook 2003. I used the "upgrade" option. I also
installed O2K3 SP1. They all have laptops and use offline
folders. Several have had various offline folder issues
since the upgrade. Is there something I need to configure
in order for them to continue to use their offline
folders? or Does Cached Exchange mode replace Offline
folders? Are there known issues with the upgrade and
offline folders? I'm not sure what to look for.
Thanks in advance for your time!
techguyasap <firstname.lastname@example.org&g...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..."Organizational folder": 'new' menu is not available
I am following article:
and I try to create an organization folder. I go to my "Public FOlder",
click "System folder".
I see EFORMS listed there. I right click the option and I don't see the
What's wrong ? Exch 2000SP3.
...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...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...import from eudora #2
I have used Eudora for many years, but am planning to set up my email in
outlook. I want to move all of my mailboxes to outlook. Eudora does not
have an export function. Do I need to go through something else, such as
Thunderbird. I can't use Outlook Express, because it only imports through
Eudora v3.0. I have 4.3.
Any thoughts on this?
"Nate Rosenthal" <email@example.com> wrote in message
>I have used Eudora for many years, but am planning to set up my email in
>outlook. I want to move all of my m...Flagging in Public Folders
My client has several users wanting to see the same message store. I
implemented a public folder. Trouble is.... messages/posts cannot be flagged
for later inspection.
Simon Beresford, MCP
IT Support Engineer
Expert Systems Ltd
t: +44(0)870 4296181
f: +44(0)870 4296182
the Total IT Service
what version of outlook and exchange and why can't they flag them?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Ou...Exchange 2007 Mailbox Folder information not updating
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I am using Entourage 2008 Web Services Edition in an Exchange 2007 SP1 UR4 environment. I have only been using the Web Services Edition for about a week and prior to that I was using the regular Entourage 2008 client for four months. In any case, the problem I am about to describe occurs in both versions of Entourage 2008. <br><br>Recently my employer's executive group decided to implement Managed Folder Policies to assist in controlling mailbox size. I was the first to...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...