Need Help #6
I am looking to see how I would go about creating a formula that would copy
the whole row, if the value is true. So if the value of F4 is "Jim" it would
copy the whole ro, and paste it to a seperate sheet.
"Scott" <Scott@discussions.microsoft.com> wrote
> I am looking to see how I would go about
> creating a formula that would copy the whole row,
> if the value is true. So if the value of F4 is "Jim" it would
> copy the whole ro, and paste it to a seperate sheet
Here's one set-up to try ..
Assume the sample t...entourage to outlook #2
i have more than 1000 letters in mac entourage, how can i move them to
ezc <firstname.lastname@example.org> wrote:
> i have more than 1000 letters in mac entourage, how can i move them to
See if something here helps:
...switching computers #2
I purchased money 2004 over the internet about 18 months ago. It was
downloaded and I was not sent any disks. I want to put 2004 on my new pc,
but do not have the correct file to install. What do I do. MSN doesn't seem
to be too helpful with their help. If I can't get it to run, I'm switching
I have been in this situation a few times myself. I simply contacted the
place I bought the software from and they gave me whatever I needed to
download the program again. Since you bought the program from them in the
first place you are automatically regist...Transferring Emails #2
Can I transfer Emails from Outlook Express v6.0 under
Windows 98SE (old computer) to my (user name) OE v6.0
operating under XP Pro (new machine)? I cannot network the
two machines. If so, How do I do it? I appreciate any help.
Copy it the dbx-files to CD and restore them to your new computer (remove
the "Read Only" file attribute. Then point to the files by going to Tools->
Options-> tab Maintenance-> button Store Folder...
For more assistance ask in an Outlook Express forum. This is an Microsoft
Office Outlook forum.
Outlook Express is family of Internet Explorer ...IF Function Help
How do I write a command that says:
=if(a1=1&b1=a number, c1/d1,"na")
How do I write the "a number" part?
Sincerely, Michael Colvin
> How do I write a command that says:
> =if(a1=1&b1=a number, c1/d1,"na")
> How do I write the "a number" part?
If I am reading your post correctly you want a cell to equal C1/D1 when
and B1= some some number
and for the cell to = "na" otherwise
=if(and(A1=1,B1=xx),C1/D1,&...Sort Worksheets #2
How do I sort sheets in a workbook, please? Thanks!
In article <email@example.com>,
"Manhar" <firstname.lastname@example.org> wrote:
> How do I sort sheets in a workbook, please? Thanks!
>How do I sort sheets in a workbook, please? Thanks!
...Publisher documents do not print. Help!
I just set up a new computer with an HP Deskjet 5440 and Microsoft Publisher
2003. Documents print perfectly from every software package except Publisher.
Publisher documents don't print at all, even after I reinstalled the printer
The entire document or just the pictures?
If it is just the pictures, click the advanced print settings button in the
print dialogue, graphics and fonts tab. Be sure "Do not print any graphics" is
Look on the HP site to be certain you have the most current driver.
http://h10025.www1.hp.com/ewfrf/wc/softwareList?lc=en&cc=us...Help in my VB Code .. to Delete
This is a multi-part message in MIME format.
I have been trying to solve this problem since morning, and haven't =
really come up with a solution. it is frustrating. please help.
i have a datagrid and got a delete column
<asp:datagrid id=3D"dgdocument" runat=3D"server" =
AutoGenerateColumns=3D"False" EnableViewState=3D"True" =
<Columns&...Help please with junk e-mails
I have set up outlook 2000 to send unwanted mails to a folder names Junk e
mails, I have copied below part of the outlook 2000 help file, can anyone
tell me exactly where I can find add in filters as I cannot find them
You can also filter messages based on a list of e-mail addresses of junk and
adult content senders. There are third party filters, which are regularly
updated, that you can add to Outlook. These filters have the latest lists of
commercial and adult content senders. For more information, see the Outlook
Web site at http://www.microsoft.com/outlook.
Thanks in advan...HELP: Need To Print Better Quotes
I am having a terrible time being able to print a good looking quote
from MS CRM. it either prints the plain quote (Address, amount..etc)
or i can print the product list (With no address, or nothing).. is
there anyway to print a normal quote as others do where you can have
the company informaiton and also all of the products that they are
buying listed there?
one would think that is the most basic feature that is not there..
don't you guys think?
ANY help you can provide will be appreciated..
Quoteless In DC :-)
Add a customized quote via Reports using Crystal.
>-----Origin...Corrupt money data file
I've posted this on the Money UK site but with no reaction ; I wonder if I
can reach a larger audience on here - I'm desperate to sort this out, thanks.
On running Money, I received a message "Money has encountered a problem and
needs to close" - no indication of what the problem was. I couldn't get past
the splach screen
I found article 836197 in the knowledge base which seems to covers this ;
did what it advised, even to the extent of doing an uninstall and re-install,
but ...Quicken Import #2
I've been using Quicken for about 10 years. I have all my checking,
investment, retirement and loan accounts in Quicken. I have never used MS
Money. I am considering buying MS Money 2004 Deluxe. My questions are: (1)
When importing from Quicken into Money, how accurate will the data and
accounts come across? (2) How does Money compare with Quicken? (3) When
importing into Money, do I use an import function and/or restore? I have a
considerable amount of data in Quicken and I would hate to edit data in the
Money accounts to agree with my Quicken accounts.
In microsoft.pub...Help building a filter on a form
Okay, I downloaded the Issue database template and simplified it greatly.
Now, I can't get the "search issues" form to work.
I have the following controls on my search form:
Application (dropdown list)
TextSearch (text field)
I'd like to modify the existing code so that when I make an entry and click
the "search" button, it will make the form footer visible (where the
"browse_all_issues" form is imbedded as a subform). That part works. But,
the next lines set the filter and turn it on...
Me.FormFooter.Visible = True
DoCmd.Mo...All help is worthy
I have set up a simple database in excel, using barcodes (i found this
easier to scan and lookup, than access) plus the people working with
this will find it simple to use. I have however reached a giant full
The database is pulled from Dave Peterson's update log worksheet, which
works very well, the problems is that on a lookup sheet( using Vlookup
) where the user scans the barcode it will pull all info from the
"database" sheet in reference to the barcode, ie: barcode number,
surname,forename,address, early greenfees purchased,mid purchased,late.
Is it possible to manipu...Outlook Connector Beta works with some accounts but others are problems
I just installed the new Microsoft Outlook Connector beta (I'm using it with
Outlook 2007 and BCM)and have had a little success and a little failure.
It works with two of my Microsoft Office Live email accounts (the free ones)
and not with the third (which is also a free one).
I also have a MSN account (email@example.com)that I've had for many years
and I thought that it definitely work with this one, and it does not.
Anyone have a clue how to get the third Office Live account working and most
also my trusty MSN account?
I should point out that I have also been using the Window...novice needs info
I am trying to construct player cards for a baseball game...what i need to be
able to do is to type constants like at bats, hits, etc. from one sheet and
have them appear at different locations on the second sheet(the actual
card)...some information such as average or era...needs to be affected by a
formula before appearing on the second sheet....also need to know how to draw
lines...vertical and horizontal in the second sheet...help..i am a dummy when
it comes to this...thanks...
Can you post a example of what sort of data in sheet 1 . Any thoughts on
VBA Noo...Need help with cursor spacing problem
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="ISO-8859-1"
I�m trying to fill in a form that�s MS Word based. I�m using MS Office X on
a Mac G4 with system 10.3.4.
When I type, the cursor seems to have an extra space between the last letter
and the place where I want to put a new one. In other words, I�m unable to
align the cursor exactly where I want it to go. It makes typing almost
imposs...hotkeys and keyup #2
I would like to thank everyone for suggestions concerning hotkeys and keyup.
What I am using is CE .Net though if there is a solution that also works in
regular windows that would be good. I am willing to give most anything a
What I have is a program that sits in the background and waits for a
keystroke to run certain functions. One for keydown and one for keyup. The
functions talk to an external device on a serial connection, but the main
thing is that I need a method to get those keystrokes no matter what
application is on top.
The impression that I get is that Hotkey will send the...Multiple mfc activex controls in one dll
In VS6, there was a possibility to define up to 4 controls, when
creating a new activex project.
No such possibility in VS2005.
Is there any way in 2005 to add an addtional one to an existing MFC
Any pointers will be appreciated!
...Linking Word and Excel #2
I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct
...Hidden tabs #2
I am using Excell 2003
If I have a file with several tabs hidden is there a way to unhide them all
at once, rather than using Format, Sheet, Unhide for each tab?
One way ..
Roger Govier gave me this sub a few years ago ..
The following will carry out the unhide
for all sheets within the workbook
Dim s As Worksheet
For Each s In ActiveWorkbook.Worksheets
s.Visible = True
GMT+8, 1� 22' N 103� 45' E
"CWH" <CWH@discussions.microsoft.com> wrote in messa...Outlook 2 K Multi User
Outlook 2000 Windows 2K
We are planning a small network 3 machines and would like to use Outlook in
a multi user mode.
What do we have to do to accomplish this?
Also where is the best place to buy Multi user licenses for Windows 2k and
office 2 K
See this page for license models:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Robert Raley <firstname.lastname@example.org> asked:
| Outlook 2000 Windows 2K
| We...Help Everything is gone. It's all been deleted.
I went on excel last on Dec 5th and I saved before exiting as usual. When I
opened the file today everything was gone. There is nothing there. The file
it's saved as is still there but it's a new page. I don't know what to do. I
need that information. HELP!
Are you sure you opened the same workbook?
What do you mean by "page"?
Excel has pages only when you print.
Do you mean a blank worksheet?
Are there any other worksheets available or just the one blank one?
Did you create a backup of the workbook when you saved?
If you "need" the inf...importing from netscape 7.2
I have Outlook 2003
I want import all my my files from Netscape 7.2, how may I do that
> I have Outlook 2003
> I want import all my my files from Netscape 7.2, how may I do that
> Thank you
Transferring Email from Netscape 7.1 to Outlook/Outlook Express
Interim Systems and Management Accounting
The easiest and fastest solution is to use Aid4Mail. It can export your
Netscape mail directly into MS Outlook....Macro needed
I have a pricing docment
Page 1, a selection of table names etc
Page 2 is the pricing table as per number 1 on the 1st page
Page 3 is the pricing table as per number 2 on 1st page and so on.
What i would like to be able to do is if i remove say number 2 on the 1st
page, that the pricing table on page 3 is removed, and so on.
Is this possible. I assume the layouts and relating table names may have to
be set up.
Message posted via OfficeKB.com
See the article "How...