copy cells from one worksheet to another
How do I make the "value" or content of a cell on 'worksheet 1' mirror or
copy the font color (and strike through) of a cell on a seperate worksheet?
- 'worksheet 2'?
Copy and paste special|values
If you were using a formula, then that formula can only return the value--it
can't change the format.
Depending on how that other cell changed, you could have an event macro do the
work for you.
> How do I make the "value" or content of a cell on 'worksheet 1' mirror or
> copy ...Moving license to a new computer
I bought a powerbook and am giving the kids my old imac. I'd like to
move Office to the powerbook and remove it from the imac. Am I going
to run into any technical difficulties doing this?
In article <email@example.com>,
Andrew D <firstname.lastname@example.org> wrote:
> I bought a powerbook and am giving the kids my old imac. I'd like to
> move Office to the powerbook and remove it from the imac. Am I going
> to run into any technical difficulties doing this?
Shouldn't. Run the Remove Office application on the iMac, and inst...Problem with Disabling a Cmd Button Based on Another field in the
I am using Access 2000.
I have a command button that should be enabled if the OwnerStatus = "Current
Owner" and disabled for any other value.
This is my code:
Function SetOneInvoiceCommand() As Boolean
Dim blnEnable As Boolean
If Me![OwnerStatus] = "Current Owner" Then
OneInvoiceCommand.Enabled = True
OneInvoiceCommand.Enabled = False
When I 1st enter the form, the OneInvoiceCommand button is ENABLED no matter
what the value is in the OwnerStatus field. However once I click the Owner
Status field once, the ...Exchange 2003 down
I installed Norton Antivirus client on my server
yesterday. Last night, it quarantined the e00.log file.
Since then I have not been able to mount either the priv
or the pub databases. I even tried having symantec
restore the file (I have a copy of the one that was
current). It made a little difference (missing log file
is now there). Any ideas of what else I should do? Both
databases showed dirty shutdown. I did the eseutil /p on
the pub database and everything seems to go ok (no longer
dirty shutdown) but cannot run isinteg against it.
"OC" <anonymous@discussio...Bring filtered data from another file
I have a Birthdays file
I have a Calendar file
After each date in this calendar file I have 4 empty lines
(assumption: max 4 birthdays on the same day)
How can I bring the names for each date from the Birthdays file.
Thanks and regards,
...not able to move FLAG STATUS column in Outlook 2003
I tried to move FLAG STATUS column from the very right
side to the left side when I am in my Inbox. IT WON'T LET
Anyone was able to do that?
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.
After searching google.groups.com and finding no answer, Kenny Shu asked:
| I tried to move FLAG STATUS column from the very right
| side to the left side when I am in my Inbox. IT WON'T LET
| Anyone was abl...Safe to Move?
I remember seeing an article about moving $NtServicePackUninstall$ files to
free up space. I think it was for Windows 2000 Server. Is it possible to do
this for Windows 2003 server?
Thank you for your help!
Hello Mr. JYC,
Yes, you can do it and if are sure that there is no need to uninstall it
you can delete it.
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.ht...Still looking for bugs ?
Just updating M2006 prices and some quotes missing, so I did it
I HAD connected to Fidelity to fetch an email and while there I checked
my portfolio to get the quotes.
While connected, I noticed my cash reserves balance was off ( interest
last month ? ),
SO in Money, I pull up "brokerage account " - "account summary" -
"Adjust balance" from lower left - click in the Cash box and - get a
bugcheck - 3 times in a row. I never tried to do this before in M2006 -
does it work for others ?? Then I got the " Send bugcheck info" and I
guess tha...Copy or Move row on condition to different and/or multiple sheets
I'm new to the world of programming in excel but have programmed elsewhere
What i am trying to do is to have a todo list setup, ive searched long and
hard and can't find anything that quite fits my bill that i can replicate and
alter to work so am asking for some assistance.
I have a workbook with six sheets, All Jobs, Evaluation, Authority, In
Progress, Completed and a helper sheet. In all jobs i have 9 columns A-I
(atm A being spare) that have information that i need to show. In column 'I'
i have a dropdown box using the helper sheet for p...Live Mail,I can't move message "unknown Error" appears
There are several messages that I want to place in folders, but when I try
to move them, I receive the message "Unable to move, Unknown Error". This is
more than annoying, as these are important messages from various
organizations I belong to. I like to archive these within the confines of
Live Mail, and I don't want to hve to go in and out to various folders. Any
help will be appreciated.
Windows Live Mail Newsgroup.
In your newsreader:
On the Web:
http://www.microsoft.com/communiti...Access to multiple Exchange mailboxes from same Outlook Profile
We have two Exchange servers that are part of the same Active Directory
domain and Exchange Organization.
Users are able to add additional mailboxes to their Outlook (2003)
profiles, but can only expand those located on the same server as their
primary mailbox. All of the added mailboxes are visible in the Folder
list, but any mailboxes located on the second server display the error
"unable to expand folders."
I know I've seen this work in the past where there were multiple
Exchange servers, any thoughts?
Exactly what rights did you give the user in order to add the extra ma...Moving Exchange 2000
I have a exchange 2000 server running on windows 2000 which I need to move
onto a new server/hardware but cannot find techincal documents telling me
how to do this. The only documents I can find are on disaster recovery which
doesnt seem to cover moving exchange across onto new hardware. Does anybody
have some a document ???
Also I would like to run exchange 2000 on server 2003, I'm guessing that
this won't be a problem to move it onto new hardware running server 2003 ??
Use the move-server method detailed here:
Neil H...Read Receipts won't move to 'delete bin' after processing
Very simply, my read receipts won't move to 'delete bin' after they are processed. This doesn't seem like a complex process. The tracking option allows me to either turn this rule on or off. What else am I supposed to do? I have receipts all over the place and I end up deleteting them manually.
You have to delete it by yourself. It wont work with a
>Very simply, my read receipts won't move to 'delete bin'
after they are processed. This doesn't seem like a complex
process. The tracking option allows me to either ...Exchange 5.5 clients cannot see the new user fr Outlook Global Add
Hi to All,
Please we need help! We have 4 branches with different domain. 2 branch is
Exchange 5.5 and 2 others are using Exchange 2000. Our Problem is when we
configured one account in Exchange 2000 it can't be seen in 2 Exchange 5.5
Global Address. This mail is use for internal use only and it is not
connected to internet.
Thanks in Advanced!
Did you configure Active Directory Connector to synchronize between your AD
and Exchange 5.5 directory?
Exchange 2000 uses AD for its directory store but Exchange 5.5 uses its own
"emslan" <emslan@d...mail moved from netscape to outlook?
Hello! I would like to know is it possible to move the
mails from netscape mail to outlook? And what is the way?
>Hello! I would like to know is it possible to move the
>mails from netscape mail to outlook? And what is the way?
<email@example.com> wrote in message
> >-----Original Message-----
> >Hello! I would like to know is it possible to move the
> >mails from netscape mail to outlook? And what is the way?
...Another question concerning powershell and exchange 2003
i am really strugling with this process. I see examples on the net for doing
this but they all do a lot more than I want so there is a ton of code to sift
through. Basicly I will query AD for a user account. I want to be able to
create the mailbox for that account. Do you have a simple example of what i
need to do to get access to CDOEXM and what parameters it is wanting. I
assume that is where my trouble is.
...How to filter previous distribtion list in Exchange 2003
We are doing the migration. We are trying to create some address view to
filter distribtion groups which are created from Exchange 5.5 before
according to the following KB (e.g. create an extra item called company
to filter it from Exchange 5.5 address book view automatically before)
However, we don't know how to filter because we cannot find the
company from the new distribution group, how to do?
...Multiple user excel file
I want to create an excel file which can be use by multiple user at a time
and the data updated in these files should bet stored in a centralized user
file. I don't know how to go about it. Could you please help me out with
this? I have created that input excel file using forms.
one way to do it is to create multiple excel files and use a master file to
link them all.
e.g. create 4 files, master.xls, user1.xls, user2.xls, user3.xls
formula in master.xls:
A B C
=[user1.xls]Sheet1!A1. =[user1.xls]Sheet1!B1. =[user1.xls]Sheet1!C1
=[user2.xls]Sheet1!A2. =[user1.xls]Sheet1!B2. =[user1....Delegates for SBS2003 Exchange
have SBS2003 Eexchange.
users can delegate their folders in Oultook client, but does not have the
properties button available after adding users from global address list, to
set permissions on folders....the button is grayed out.
Do I have to enable this feature somewhere on the server in excahnge manager
...Exchange 5.5 / 2000 /2003
Why does so many people send posts regarding Exchange 2000=20
and 2003 in the wrong forum??
This forum is regarding Exchange 5.5
There=B4s forum=B4s for them all, PLEASE place the questions=20
in the right forum
You need to read this:
For Exchange news, links and tips, check:
"gladefoged" <firstname.lastname@example.org> wrote in message
Why does so many people send posts regarding Exchange 2000
and 2003 ...list workbook names except one
Hi all, below macro list all the workbook names in column "A" which
exists in a folder. What code line i should add in below macro that
if there is any worbook exists with the name "Closed.xls" in the
folder then it should not be listed with the other workbooks names.
Please can any friend can help
fldrnm = Sheets("INFO").TextBox3.Value
fName = Dir(fldrnm & "*.xlsm")
Do While fName <> ""
c = c + 1
Cells(c, 1) = fName
fName = Dir()
Replace this line of code...
Cells(c, 1) = fName
with thi...Moving Pages between two publications
How can I move several entire pages from one document to another? Not simply
the content of the page, but the format as well as positioning?
Select all the elements on one of the pages and Group them together (a
little icon will appear at the bottom of the bounding box - click it to lock
the group) before you Copy and paste to the other publication.
"FrankDe" <FrankDe@discussions.microsoft.com> wrote in message
| How can I move several entire pages from one document to another? Not
| the content of the ...Move mailbox rights in Exchange 5.5 #2
What is the most restrictive set of rights that would allow an administrator
to move mailboxes between 2 servers in the same site? Providing the
administrator an admin role on the Servers container, on each server, or on
the Private/Public Information Store gives him undesired privileges (like
changing default storage limits).
Thanks in advance for any assistance.
...Move users from none Business Unit to other
hi, is it possible to move a user from one business unit to other ?
Yes it is. However when you move them they will lose their security role so
you will need to add a security role to their user record
"M. Ceccacci" <email@example.com> wrote in message
> hi, is it possible to move a user from one business unit to other ?
should have said!!
to do this go to settings, business units, users then open up the users
record then click actions - change business unit.
once done make sure you reassign...moving companies moving loans moving budget
moving companies moving loans moving budget http://www.movingcompanies.co.il