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...Trouble downloading messages
When I open OE and it starts to download my messages, it stops and gives me a
message that (x) of (x) tasks have not completed. I have to close that
message screen and then click on the send/receive button to get the messages
to download. If I close out OE and go back in within a short period of time,
this does not happen. I don't check my e mail everyday and sometimes there
are a large number of messages to be downloaded, so I was wondering if this
might have something to do with it.
Turn off e-mail scanning in your anti-virus program. It is a redundant
layer of protecti...shared workbook in excel 2007
So many horror stories about shared excel workbooks crashing or losing data. I would like to have a shared excel workbook for our budget, shared among 30 people, who would enter in their budgets for specific departments. Are there users that have sucessfully utilized shared workbooks with 20-30 users? If so, what tips/secrets do you have to avoid the pitfalls of other sites, who have problems???
Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Create a Quiz with Free Quiz Template in Adobe Flash MX, Flash 8, Flash CS3, Flash CS4
http://www.eggheadcafe.com/tuto....qfx file in excel
my bank for some reason will only allow me to download my statement in a qfx
file (quicken) but i dont have any quicken programs i use excel to manage my
finances how can i open this file up???
If the bank does not have .text (.txt) or comma separated variables (.csv),
which would probably be listed as spreadsheet format, then
I would complain to the bank.
Meanwhile you could copy and paste from your checking activity
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: ...Percent increase in excel #2
How could I do a percent increase when I have two tables with money values,
one from last year and one from this year?
A1: <last year's value>
B1: <this year's value>
Format C1 as a percentage.
In article <29182E64-291B-4B10-804E-88FE105D24AB@microsoft.com>,
"Aiko" <Aiko@discussions.microsoft.com> wrote:
> How could I do a percent increase when I have two tables with money values,
> one from last year and one from this year?
Thank you for your answer, I send you and e-mail because I came up with new
pro...Pasting excel chart into powerpoint
When I paste an excel chart into powerpoint, it's not pasting
proportionally. I've added text boxes to the chart (in Excel). Also, the
original chart is a full page in Excel, however when I paste it into
Powerpoint, it's being reduced in size. when I enlarge it, the text boxes
(that I added) then overlap one another in powerpoint, where they didn't do
this in Excel. I just switched from '97 to 2003 and this wasn't a problem.
Perhaps I'll also post this to the powerpoint newsgroup, in case the problem
is there instead of excel.
I have so...Excel Formula Help #6
I have six numbers and letters in a cell on a spreadsheet and I am using the
formula =RIGHT(F1,1) to obtain the first letter or number. However the
formula is not picking the first number or letter in the string in all cases.
Some of the cells are left blank.
Any help would be much appreciated.
> .. Some of the cells are left blank
Probably these are trailing white spaces
which can be cleaned up using TRIM
Try it as: =RIGHT(TRIM(F1),1)
High-five? Click YES below
Downloads:23,500 Files:370 S...Unable to start up my Excel files
One of my users have this odd issue with his Excel 2003. He's unable to
start the files directly but instead he must start a blank excel sheet then
open his files from there. Is there a solution to this issue?
Dell 170L P4 800mghz 1gbram
Windows XP Pro SP2
Office 2003 SP2
Could the problem be that he cannot open files by double-clicking on them
from Windows Explorer, but must open Excel (which will launch a blank sheet)
and then open them directly from there using File / Open...
If so then tell him to try Tools / Options / General / untick 'Ignore Othe...Running Balance in excel pivot table
Product, transaction no
have data fields:
qty rec, qty iss, balance (calculated field: qty rec - qty iss)
want balance to be a running total with base field of product
so want something like:
inv-----------------0--------------------...drawing excel like grids on access reports
I want to draw excel like grids on my access reports. The line should start
from the top of each label in the page footer to the bottom of the
corresponding text box in the page footer.(For each text box in the detail
section, there's one unbound text box in the page footer to display totals).
I don't know how to do this. can anyone please help me?
Can't you use rectangle or line controls in your various sections? These
should work unless your sections are set to Can Grow. If this is the case,
you may need to use the Line method ...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?
...Why is Excel trying to access the network
I'm pasting some text into a cell - it did come from a website, but
it's not a link or anything.
It's just plain text - why the need to access the network?
Maybe it's another cell, switch to formula view and see
if you see something else. Because the formula view may
not show everything, you might want to copy to another sheet
so you can adjust columns to see your formulas better without
affecting the column widths on the original.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
...Excel no more new fonts
I'm getting the message "no more new fonts may be applied
to this workbook". How can I get around this?
Any chance that you have a lot of charts in the workbook?
There's a limit of 256 fonts in a workbook and each chart uses
up two of them.
Check here for more info.
"Tuan Ma" <email@example.com> wrote in message
> I'm getting the message "no more new fonts may be applied
> to this workbook". How can...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.
...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...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...MS Deluxe 2008 Pre loads wrong catagories after download
Seems that I can't stop Money from entering the wrong catagory after a
download from my bank. Everything shows as Groceries. How can I get the
download either to enter the correct information or none at all?
Thanks in advance.
XP SP2, Money 2008 17.120 xxx
In microsoft.public.money, Birdflu wrote:
>Seems that I can't stop Money from entering the wrong catagory after a
>download from my bank. Everything shows as Groceries. How can I get the
>download either to enter the correct information or none at all?
>Thanks in advance.
>XP SP2, Money 2008 17.120 xxx
...Excel 2002 Problem
My first message accidentally sent before I finished
typing in the second problem.
Second problem again: Macro buttons that I have created
and placed on my Formatting toolbar do not work when I
open Excel 2002 and have two or more workbooks open. The
macros for each button are stored in my Personal
workbook. I get a message saying "A document with the
name PERSONAL.XLS is already open. You cannot open two
documents with the same name." However, if I go to
customize toolbars, I can reassign the macro to each
button and the buttons work fine. If I close Excel and
open ...Virus in Excel ???
I can't right click, copy and paste a cell. I can use ctrl c and ctrl v but
that puts the info in the clipboard. The blinking dotted box no longer
Is this in a worksheet of yours, that nobody else has
used? There is a way to use VBA code to prevent you from
using right click to do anything.
>I can't right click, copy and paste a cell. I can use
ctrl c and ctrl v but
>that puts the info in the clipboard. The blinking dotted
box no longer
Yes a new worksheet. The right click works. I can copy but when ...