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...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...CRM appointment form instead of Outlook appointment form
In the outlook client, when I click the "Create New Appointment' button in
the CRM toolbar, the Outlook appointment form appears. Is there any reason
why it is not the CRM Appointment form that shows? Is there a way to use the
CRM form instead?
I know you can go in the "Activities in CRM" folder and create a new
appointment from the Activities screen, but at this point, you no longer see
the Outlook Calendar, so it is now very convenient, nor is creating a outlook
appointment, clicking the track in CRM button and finally adding the missing
field in the CRM appointme...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...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...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...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 ...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?
...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.
...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...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" <firstname.lastname@example.org> 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
...Moving from Outlook on PC to Entourage on Mac
I'm trying to move to a Mac from a laptop that died and use the Office 2008
for Mac. Can't find the Pst file on the laptop hard drive and it doesn't
seem easy to import from outlook. Any suggestions?
Locations are here
Outlook requires the data file to be located on your current system, (Not so
it overwrites any existing data file) before you open it within Outlook (or
"GeorgeK" <GeorgeK@discussions.microsoft.com> wrote in message
news:64D74ACC-C994-441B-8EA1-FDC4D30B3F88@microsoft.co...Moving Folder error
Using OL 2007, I am moving some folders and I get a error message 'Folder is
Any ideas ? I can copy the folder elsewhere but not more it.
"Ronnie" <rarneja@REMOVEMEnc.rr.com> wrote in message
> Using OL 2007, I am moving some folders and I get a error message 'Folder is
> Any ideas ? I can copy the folder elsewhere but not more it.
Are you using an Exchange account or some other type of account? If another
type, what? Have you emptied your Deleted Item...Moving between worksheets
I had someone do this for me. This is an Excel file with 4 worksheets. The
two pertinent ones are called 'Schedule' and 'Version'. When save the file
it updates the version of the file with a date/time stamp on the 'Version'
worksheet like this.
Version Last Saved (Date/Time)
2004.08.282141 8/28/04 9:41 PM
2004.08.282140 8/28/04 9:40 PM
2004.08.282140 8/28/04 9:40 PM
2004.08.282139 8/28/04 9:39 PM
2004.08.282136 8/28/04 9:36 PM
I would like it to update the 'Version' worksheet and then jump back to the
'Schedule' ...Problems with ungrouping and selecting one item to ungroup
I have created a flyer in Microsoft Publisher 2003 by using two text box and
adding text. I then inserted a clipart. I have grouped the entire flyer, but
would like to ungroup just the picture, but I am having problems.
I checked the Publisher Help section, which told me to click on the Drawing
toolbar. I could not find the Drawing toolbar, and even looked under View,
Toolbars, and Customize...but found nothing. Then reading a post on this
board, I found that it might be under "Arrange," so I looked there. I found
the group and ungroup commands, but they are "gray...Moving Cache
I have started a new computer with Vista Ultimate. I have outlook 2003 up
and running and have copied my PST file from my old Windows XP Pro computer.
I did have a lot of cached addresses which were not in my contacts. I copied
the .NK2 files from the XP to the Vista computer, replacing the currect
*.NK2 files in the roaming folder.
The address do not appear when I try to address a new email. Am I missing
Is your profile name the same on the Vista Machine? Where did you put =
Milly Staples [MVP - Outlook]
Post all replies to the group to ...data validation not working on one sheet
I have a series of cells using a Named Range for a data validation list.
Until yesterday it worked fine. Now it doesn't work. The cell, list, range
is all the same. I've done the Edit/Goto/Special/Data Validation/All and it
highlights the right cells. I also tried to set up something very simpl:
A1,2,3 have values aa,bb,cc. I then set up b2 for data validation, list,
and drag the range over a1,2,3. Error alert is checked. Click on b2 and no
drop down. You can key in anything you want.
On all other worksheets data validation works just fine. Anybody have any...MRP V10 Move In and Move Out
Service Pack 1, has anyone seen any issues with the Move in and Move out not
working for 'make' items when MRP regenerates?
I seem to be able to create a situation, where if I change the MO Due date
or change the Sales Order In House Date, (change one OR the other so they
dont align with each other) MRP will suggest a new MO instead of moving the
existing. MRP is suggesting MO's with no demand.
MO Due Date 07/1/2008
Sales Order In House Date 07/03/2008
If I change the Sales Order In House date to 06/27/2008 (and leave the MO
MRP will suggest a ne...Locking records in a form based on a combo box selection
I have read all I can find but still can't get this right. I have a combo
box with a selection of either Yes or No in a field called P5Pd and I want to
lock records if it Yes is selected.
I have the following code, but it is locking ALL records and not just if
P5Pd = "Yes"
If Me.P5Pd = "Yes" Then
Me.AllowEdits = False
In addition to the above information, I would like to say that I can edit
other records, but once I have passed that record either forwards or
backwards (e.g. if it is the 3rd record, I can edit ...