Can I use "find / replace" to automatically "Insert Rows" in a do.
Have a long column of numbers
Every time I see the number 5, I need to insert two rows. Doing this by
hand is tedious. Can you help me find a shortcut?
The IF function does not do this, right?
Not 25, 35, 5351, just plain old 5?
Dim FirstRow As Long
Dim LastRow As Long
Dim iRow As Long
FirstRow = 1
LastRow = .Cells(.Rows.Count, "C").End(xlUp).Row
For iRow = LastRow To FirstRow Step -1
If .Cells(iRow, "C").Value = 5 Then
...Outlook and message rules- can't get one to work?
I have set up message rules to divert mail from my inbox to various sub
folders or new folders. I use these:-
Check messages when they arrive\ from people or distribution list \ with
specific words in the senders address \ with specific words in the subject or
Now the problem is that some of the messages are recieved from people in my
address book and when they send a message sometimes their name and address is
in the 'from' and other times it is just their name and so the ones with just
their name do not get moved across to the folder I want. I have added their
name or...Entourage 2008, Web Services Edition
Operating System: Mac OS X 10.6 (Snow Leopard)
Downloaded update to Office for Mac from the web. When installed, got a window that says? <br><br>"Entourage 2008, Web Services Edition can't be installed on this disk. A version of the software required to install this update was not found on this volume." <br><br>"To learn how to fix this issue, see "I can't install Office 2008 for Mac updates," at <a href="http://www.microsoft.com/mac/help.mspx">http://www.microsoft.com/mac/help.mspx&l...Can I make my Contacts Folder my Default
Does anyone know if I can make my contact folder the default folder rather
than the Global Address List?
On 3/8/2010 7:36 PM, Wendy wrote:
> Does anyone know if I can make my contact folder the default folder rather
> than the Global Address List?
Ctrl-Shift-B (or just click the Address Book icon)
Tools -> Options
Leonid S. Knyshov
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
...How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
File>Print Area>Set Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
...Can't repair CRM
When I try to repair CRM on a few laptops, I get the following message:
Setup failed to locate binary file microsoft.crm.metadatahelper.dll verify
that the source folder is configured with Everyone Read Access.
I am trying to do a repair off the original CRM CD.
Any ideas why this is happening?
...Can't find outlook archive.pst
I'm constantly getting "can't find Outlook archive.pst"
error message when I launch Outlook XP. Does anyone know
how to get rid of this error message?
Richard <firstname.lastname@example.org> wrote:
> I'm constantly getting "can't find Outlook archive.pst"
> error message when I launch Outlook XP. Does anyone know
> how to get rid of this error message?
Either create an Archive PST or disable archiving (Tools>Options>Other)
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...Can a user's Worlplace be defaulted to a standard one
Is it possible to set a standard Workplace that users will see based on
either their role or team?
We have a client who wants to set standard worplaces for respective
Ian Watson had a good method--
"simply click on Workplace bar, then just above click on "personalize
Workplace" then tick on or off what you need"
This could also be done through changing the security role to allow
certain privaleges. You cant change a system security role, you have
to copy it and rename it. Settings | Security Roles | highlight the
role you want to copy | ...whihc microsoft office can i use to determine loan amortization
I am looking for programs wherein I can determine loan amortization
"Justin Reyes" <JustinReyes@discussions.microsoft.com> wrote in message
|I am looking for programs wherein I can determine loan amortization
You need Excel, not Access
remove nothing for valid email address.
...Unable to close a PO in Edit Purchase Orders
I am trying to close a 2005 PO in the Edit PO screen but everytime I click on
Process, nothing happens. I am getting this on 2 POs and I do not receive
any error messages. Please advise. I'm trying to clean up POs. Thanks!!
You may have corrupt records. Can you tell if data is missing from
any of the fields in the PO? If so, you may need to go into the
tables and correct the records.
Hope this helps,
MCP-GP, MCT, MVP
East Coast Dynamics
...Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...97: How can I find duplicate entries in a column?
Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Message posted from http://www.ExcelForum.com/
Insert a helper column:
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
http://ww...how to edit Adobe file
how to edit Adobe file
Most certainly not in Word.
pdf files, I'm assuming that is what you mean by 'Adobe files', are 'fixed'
files. Their layout is frozen so they look the same on any machine and can
not be edited.
If you still want to edit such a pdf file, you will have to convert the file
to something else, edit it, and then save the result back as a pdf. The best
tool to do the conversion of pdf files to Word documents is probably Acrobat
Professional. Unfortunately, that is a rather expensive product to use for a
few simple conversions. There are ...Chart turns gray.. can anyone help
Hi, I am working with a large file.. but not as big as
others. This one has a few charts. When I add another
it starts acting weird... turning totally gray unless I
click on it...? its it the fact that its not embedded or
not in front or in back of the worksheet? Thanks for any
helpful ideas on correcting this.
Go to Options on the Tools menu, click on the View tab, and under
Objects, select View All.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Steve Kay wrote:
> Hi, I am working with a large file.. but ...Can't link a graphic?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Email Client: pop
I've been told on this forums several times that one cannot have a graphic with live link in your email signature. <br>
Still, I've recently received a few email with small buttons that link to facebook and myspace in Entourage. How are these folks achieving this? thanks.
> Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power
> PC Email Client: pop I've been told on this forums several times that
> one cannot ha...In POwer POint 2003 can I gradually add text in the same slide?
I want to gradually add text in my presentation within the same slide. For
ex: The beginning of an equation and click the mouse to complete the equation
as I explain it.
Read the instruction here:
Bart: "According to creationism, there were no cavemen."
Homer: "Well good riddance, their drawings sucked and they all looked like
"PP HELP" <PP HELP@discussions.microsoft.com> wrote in message
> I want to gradually add text in ...Remove Reason Code from Receipt
Me again! We don't want to show the reason code on the customers
receipt/invoice especially as is adding too many lines to the paper copy.
How do I stop the Discount Reason code from printing on the customers
I'd be interested in an answer to this too!
"jonathan" <email@example.com> wrote in message
> Me again! We don't want to show the reason code on the customers
> receipt/invoice especially as is adding too many lines to the paper copy.
> How do I ...Can not see Public Folders in OWA after upgrading Front-End Server
We just performed an in-place upgrade of one of our Exchange front-end
servers. Everything was upgraded successfully, but now our users are getting
the following error when launching OWA and trying to access their folder list
as Public Folders are not showing: Microsoft Internet Explorer / An internal
server error occurred. If you click OK, it will let you continue working,
but you can not access Public Folders. Has anyone seen this type of issue
and if so, how can we correct it? THANKS!
...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...How many recordset can be opened simultaneously for a MS-Access 2000 Database for adding /editing records
Can someone please suggest how many recordset can be opened
simultaneously for a MS-Access 2000 for adding /editing records.
I also want a comparison with MSDE for the same.
> Hey Friends
> Can someone please suggest how many recordset can be opened
> simultaneously for a MS-Access 2000 for adding /editing records.
> I also want a comparison with MSDE for the same.
Uhm... If I remember correctly that would be max. 20 connections.
Successive CRecordset::Open(...) requests would fail.
I don't know this parameter for MSDE. There's a limit in...can't move chart to new worksheet
I am creating a an embedded chart and then move it to another worksheet that
would contain all my charts.
After I create the chart I want to move it to another sheet. here is my code:
ActiveWindow.Visible = False
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlMaximized
ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)",
It gives me an...Removing Outllook 2002
In trying to install Office 2003, it says I must remove
the previous version (Outlook 2002) to install Outlook
2003. How do I get it uninstalled/removed? I have
tried "control panel" but Outlook is not listed there.
Control Panel doesn't separate office products. Pretend you're installing
outlook 2002 from the CD. It will detect its presence and ask if you want
to update or remove it. Select remove.
"Sam" <firstname.lastname@example.org> wrote in message
> In trying to install Office 2003, it sa...how can i get %. like 100+85+75+96=89.0%
I want the pecentage like 100+85+75+96=89.0%
Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 enter =SUM(B2:E2)/4. If you want it displayed as %,
devide by a further 100, format cell as percentage, 1 decimal point -
=SUM(B2:E2)/400, or =(100+85+75+96)/400, or else enter the values as
percentages 1, 0.85, 0.75 and 0.96, and then devide by 4 at the end
"Elvis Perez" wrote:
> I want the pecentage like 100+85+75+96=89.0%
Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 ...can IF leave a cell EMPTY ??
I'm attempting some simple (to me at least) data analysis and am running
into trouble with zero values in the data array (region). These zero
values (null string: "", actually) represent non-existant data that I'd
like the chart to ignore, but as the array actually contains formulas
the chart engine does not see an empty cell.
Is it possible to use IF to cause a cell to appear Empty (ie,
IsBlank(cell) == True) ?
Something like: " = if (condition, reference, Empty) "
My raw data consists of date shipped and date recieved; I have created
an array (Mon, Tue...