Delete Rows #2
I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet. Any
That worked great, thank you so much.
How do I run the same macro for another name right after this one?
Gary''s Student wrote:
> This macro:
> Sub remover()
> v = Sheets("Sheet1").Range("A1").Value
> For Each r In Sheets("Sheet2").UsedRange
> If r.Value = v Then
> Exit Sub
> End If
> End Sub
&g...Unreconciling Multiple Rows In Money
I would like to know if there is a way to unreconcile multiple rows in
Microsoft Money? I can do one at a time, but I need to do a large
number of them and don't want to do them one at a time.
I've tried to contact Microsoft directly about this but got passed to
the company that I bought my machine from, who passed me off to
another support number in their company - which tried to charge me for
asking this question.
Any info on this would be great!
In microsoft.public.money, Doug wrote:
>I would like to know if there is a way to unreconcile multiple rows in
>Microsoft ...Custom formatting #7
How can I do the following custom formatting –
I need trailing dots before the number
Thanks for any help
Right Click > Format Cells > Select Custom
Enter "........ "0.00
"John Knoke" <JohnKnoke@discussions.microsoft.com> wrote in message
> How can I do the following custom formatting -
> I need trailing dots before the number
> Thanks for any help
Use a custom number format of *.#,###.00
Note the period between the * and the f...Importing five row list from word 2003 to excel
I have a Word five row list I would like to import into Excel in a five
column list. Every hundred items or so their is a new heading. What do I do?
If it is in a word table you can cut and paste it. But you will have to
Once you get it into excel you can sort it and delete the duplicate
Message posted from http://www.ExcelForum.com/
...Convert time stored as decimalised number to time format
How can I convert 3.5 hours to 3:30:00?
A1/24 and formate as time
> How can I convert 3.5 hours to 3:30:00?
...How to paste a cells row from Excel to a PowerPoint 2003 Table row?
How to paste a row of cells from Excel to a PowerPoint 2003 Table row?
PowerPoint 2003 pastes all the row cells values in every cell in the row in
the PowerPoint table if I select the row in the PP table before the pasting.
PP pastes the row as an overlapping column if I place cursor in the first
cell of the target row before pasting.
...Keeping the format but update the data
I have a report I run everyday. I want to update the data, but keep the
column sizes and formatting. Any suggestions? Anybody suggest a good ebook to
become more formuliar with excel?
JoeM, this could be as simple as recording a macro during the formatting of
the sheet after importing the data once. Then each day, after importing the
new data, you simply run that macro.
As for online eBook's for Excel, I'm not actually aware of any although I
suspect a Google search would turn up several. It's hard to beat the "For
Dummies..." series of hardcopy...NEED HELP-wrong formatting saved ??
After using word 2007 and saving a word file, it changed the formatting from
the previous file (i think it was .wps microsoft works word processor) and
now its all messed up.....I think I saved it in some other wrong encoding
standard......now, whenever I open this file now half of it is in some weird
looking unreadable characters....like this
is what seems to happen once the system breaks its laws from the inside.
......couldnt find online solutions...does anyone have any suggestions or
s...Conditional Formating: linking to display another cell
Hello, I am trying to make a traffic light with symbols and I've read to 'use
a separate cell for the dropdown choices, with their resulting value linked
into the formatted cell through an IF function, using the character that you
=IF someone enters '1' in B8, THEN display contents of $C$4 (will it display
font and attributes?)
=IF someone enters '2' in B8, THEN display contents of $C$5
=IF someone enters '3' in B8, THEN display contents of $C$6
But I've been reading everywhere and CF is very new to me and I need ...coloring in rows
Could somebody please help me with the following problem?
How do I set a conditional format that if L5,M5, or N5 = �BAD� the
highlight the row yellow, otherwise leave it the standard non fil
koba's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2863
View this thread: http://www.excelforum.com/showthread.php?threadid=48371
Select Row 5. Format> Conditional Formatting. Formula is:
Set ...Newbie Needs Help With Formatting E-Mails
Newbie Needs Help With Formatting E-Mails
I'm new to this site and would appreciate some formatting help.
I created a new Word doc and copied and pasted some graphics and some
simple text boxes in to it. The graphics and text boxes were created
in Powerpoint by someone else. Looks fine on my screen.
Before sending it out via e-mail to an Outlook e-mail group I have, I
first sent myself a test message to see what it would look like on the
receiving end. It looks a mess! The text boxes are all over the
place, as is the text that is not in a box. Also, everything slide
over to ...2003 format in 2007?
I'm used to Outlook 2003, but I just bought a new computer and installed
Outlook 2007. I view a week at a time, and I prefer the calendar format in
2003 -- it shows the whole week in two columns and I didn't have to scroll.
Is there a way I can use the same format in 2007?
No, unfortunately that view had to be removed to enabled calendar overlay.
Try a two week view: http://slipstick.me/2wk
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:dai...Excel CSV leaving out empty columns from row 17 onwards
Excel omitting commas in random ways !!
Anyone come across this ?
When I save this file in csv using excel 2003
A,,C,D,,21-Nov-06,27-Nov-...How do I insert a radio button into a spreadsheet?
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=37768
This should help you.
...Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo)
I've joined the legions who've encountered this problem with the
OutputTo method in Access:
Run-time error 2306
There are too many rows to output, based on the limitation
specified by the output format or by Microsoft Access
A lot of people seem to have encountered it. The reason is because
OutputTo defaults to an old version of Excel which only allows 16K
A lot of people also suggest using TransferSpreadsheet instead, but
that caused me a lot more problems (putting a single quote in front of
my text data)
Intellisense for the command does not list what your options are for
th...Excel Question: How to Delete All Blank Rows from a worksheet?
Hi, I'm brand new, and that is my question. I just spent 2 hour
laboriously mousing along deleting row by row, every other row thinkin
there's gotta be a better way. (I could've done it of course if the
were adjacent, but they were interspersed with my good data). I'm
little behind the times: agile with keystrokes but less so with mous
[think I was quicker in Lotus DOS! (actually "TWIN")]. But I do play
Message posted from http://www.ExcelForum.com
"DaveThePianoGuy >...formatting #2
Is the strikethrough formatting option no longer available in Publisher? Or
if you need to use a strikethrough do you have to draw a line through the
text? The line does not always stay in the same spot when you group and then
have to paste on another page.
> Is the strikethrough formatting option no longer available in
> Publisher? Or if you need to use a strikethrough do you have to draw
> a line through the text? The line does not always stay in the same
> spot when you group and then have to paste on another page.
You have the an...Trying to get a type of video file format to open and run on my we
I created a video using Windows Movie maker and saved as .wmp file. I saved
it to my computer and then inserted on my web page under Front Page 2003.
Nothing! I then converted the file to avi format - still nothing! I then
tried mpeg4 still nothing. The manual is next to useless on this subject.
Anyone tell me what I need to do so that when a user opens up the page the
video plays automatically.
Save as a .wmv and insert a suitable player into the page.
For IE only,
Insert->Web Component->Advanced Controls->ActiveX Control
Choose Window...Text formatted email
I am trying to email a long hyperlink path to some one that can only receive
text formatted emails.
When they receive the email it, the hyperlink gets converted in to 2 lines,
top line is a hyperlink (path incomplete) the second line is "text" with the
balance of the hyperlink path.
I placed < > around the hyperlink and it still splits in to 2 lines.
Is there any way to keep the full link path intact?
Tiny URL to the rescue! :-)
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Cr...Outlook2003 inserting a Hyperlink
Why can't I insert a hyperlink in a message to a file
using Outlook 2003, composing in HTML, or Rich Text
format, using Word 2003 as the editor? When I select
Insert (from toolbar) Hyperlink is grayed out. Is there a
setting someplace to allow this?
...Dynamically inserting popup menu into MDI app when there's a CView
I have an MFC MDI app. It has the standard IDR_MAINFRAME main menu,
and one type of CView defined with its own IDR_AITYPE menu.
Now I have to detect whether a custom DLL is loaded, and if so an
extra popup menu is added to the main menu, defined & controlled from
I can modify the IDR_MAINFRAME menu from the mainframe's OnCreate
handler. I call the DLL, which loads the custom menu resource & does
an InsertMenu into the window's menu. This works well.
But I can't figure out how (or where) to insert the popup menu into
the main menu when a CView is active & re...Import data not in correct format
Import data reads: Need to do statistical anaysis on hundreds of numbers
Cell value # of Cells don't want to enter the numbers by hand.
...Move data from column to rows HELP!!!
Hi thanks for taking the time to look at my problem, currently i have
column that has thousands of rows of information in it, it looks lik
numbers that go on into mabye the 5000-6000 range
what i need to do is have that data moved So it looks like this
A | B | C
40432 | 32432 | 532
432654 | 523 | 523
3432 | 52432 | 111
532543 | 532532 | 222
So on and so on,
so instead of 1 column with 6000 lines it ...Four Conditional Formats?
I am attempting to set up a template for someone else to use on another
machine, and wish conditional format a cell such that it has four
The first is based on an adjacent cell value, and if this is met, then
it is colour 1.
The remaining three, are all AND statements involving the first cell
and another cell value being less than date A, less than date B or less
than date C.
Is this possible to do? I have limited VB knowledge, and am wary of
using add-ins as the people I am sending this to to use have limited
I want to assign a number to a certain conditional format. When the
condition is true it should put a 1 in the cell and when the condition is
false a zero or nothing should be assigned. Anyone? I seem to make the wrong
code all the time.
Use the same test that the CF uses, and return 1 for TRUE and "" for FALSE.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jootje" <Jootje@discussions.microsoft.com> wrote in message