Repeating data on matching cellsWhen the data column C matches the data in column A, I need the data
in columns C and D to be repeated for all matching rows.
For example:
This is my data:
a b c d
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701452-4 008710
009701449-2 071712 009701455-7 008710
009701449-2 071712 009701460-1 008710
009701449-2 071712 009701465-6 058617
009701449-2 071712 009701467-8 059602
009701452-4 008710 009701468-9 059602
009701452-4 008710
009701455-7 008710
009701455-7 008710
009701460-1 008110
009701465-6 058617
0097...
Sorting chartsHi All,
I want to sort the charts in a spreadsheet on its name and i have the
code to do this. but my code sorts the charts based on the index
value.
Is there any way to sort charts by there name.
thanks,
Navin
The index value is the Z order, where 1 is the one behind all the others,
and the highest number is in front of all the others. Adjust the Z order
(Bring Forward, Send Backward), then run your sorting routine. Or provide
the list of chart object names to the procedure and use these in order to
move each chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom...
where is that save data feature for backup?Hi All,
On sql 2005, where is that console that allows me to save my data
to a directory for easy backup? If I remember correctly, I can set this
on a schedule too? I was shown this a few years back, and for
my life I can not remember where it was. :'[
Many thanks,
-T
ToddAndMargo (ToddAndMargo@invalid.com) writes:
> On sql 2005, where is that console that allows me to save my data
> to a directory for easy backup? If I remember correctly, I can set this
> on a schedule too? I was shown this a few years back, and for
> my life I can not remember where it ...
Formatting Lost in Excel 2007Good afternoon,
I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.
We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no f...
Printing WORD docs from a formI have a button on a form and I want it to print a Word mail merge document
that contains data from the database that is linked to my application.
I'm using the following code but always get a 5922 error - Word can't
open the source... All variable names contain valid data, so that's NOT
the problem.
With appWord
.Visible = True
.Documents.Open pathdocname
With .ActiveDocument.MailMerge
.MainDocumentType = wdFormLetters
strConnection = "DSN=MS Access Databases;" _
& "DB...
problem with BOLD. ITALIC...using Word as editorI compose a msg using Outlook. Word is the editor. I set a word in bold
ot italic. I send msg to myselg, reading in Outlook. The bold or italic
is gone. What to do?
Thanks,
Leo
Are you sending the message as text only? If so all formatting will
disappear. If you want to retain your formatting you'll need to send your
messages as HTML. You can check this in your Outlook options.
--
Martin Sketchley | www.msketchley.pwp.blueyonder.co.uk
(remove EGGBEANSANDSPAM to reply by e-mail)
...
Adjusting one data set based another
I'd like to compare two sets and report a result that shows how one data
set would plot if related to the other set (sorry, I know that's poorly
worded). Here's an example:
Sample #1 Sample #2
25% 0.26 25% 0.264
30% 0.31 30% 0.317
35% 0.36 35% 0.365
40% 0.41 40% 0.426
45% 0.45 45% 0.5
50% 0.51 50% 0.569
55% 0.56 55% 0.644
60% 0.62 60% 0.72
65% 0.69 65% 0.779
70% 0.75 70% 0.835
75% 0.84 75% 0.901
80% 0.93 80% 0.968
85% 1.03 85% 1.049
90% 1.12 90% 1.108
95% 1.24 95% 1.194
100% 1.4 100% 1.242
So, in the above data for example, at 50%, sample #1 reports 0.51 in
sa...
Windows XP: Open file in read-only: Word, Excel, VisioI'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
Thx.
I used to save files like this in "read only recommended" mode.
File|SaveAs|Tools|Ge...
ChartingI am trying to figure out how to plot a chart of T Vs (V1-V2) without
actually creating a Column to calculate V1-V2. Please help. Thanks
Here's an example. Put T values in A2:A12, V2 values in B2:B12, and V1
values in C2:C12 (B1 and C1 are reserved for labels). Press Ctrl-F3 to
open the Define Names dialog. Enter a name like DeltaV in the name box,
type an equals sign in the Refers To box, select the range containing
V2, then type a minus sign, then select the range containing V1, and
press Add. The refers To box contains the formula:
=Sheet1!$B$2:$B$12-Sheet1!$C$2:$C$12
Now...
AutofillHello.
When I click the black plus mark to autofill a column, instead o
calculating the formula that I entered in the first cell, it repeat
the same answer as in the first cell. How to avoid this?
should I try reinstalling excel software?
-------------------------------
Sometimes, I get correct answers without problems. If this becomes
problem if we employ the whole excel sheet? Once I used all columns an
about 100 rows. After that, I have this problem.
=================
eg.
Let us say, that we need to multiply the first 2 columns. the correc
answer needed is in the 3rd col. and the wrong a...
Not enough memory error trying to open a Word X fileVersion: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
Error message: "There is not enough memory or disk space available to complete the operation" when trying to open a Word X file in Office 2008 in Leopard or Snow Leopard on iMac that works fine in Word X despite resaving a new version. Any tips?
Not enough information to answer.
Check that OS X and Office 2008 have the latest updates applied.
Use Disk Utility to Repair Permissions.
Check the access your user ID has to the system Temporary folder (don't
worry about this if you ar...
Cannot upgrade to Word 2007 from Word 2002 as word crashes when trWe have a word add in that programatically inserts an auto text table then
adds rows to it. This works ok in Word 2002 but occasionally crashes in Word
2007 - this is not a consistent crash when we carry out the same operation it
happens in no specific sequence. The only place we are able to track it down
to is the auto text table inserting rows. Word itself is crashing.
We are using COM AddIn written in VB6.
Does anyone know of any key differences/issues between Word 2002 and Word
2007 that could cause such an error.
Or is there a better way to attach a debugger/word debugg...
Money 2007 Premium Application ErrorHi, I started getting an application error while in Money and now can't get
into it at all. I get error message unknown software exception (0xc000000d)
occurred in the application at 0x7813e792. I've uninstalled the application
then reinstalled it using the CD an I get the error message. It occurs after
entering my passowrd when the Home page is displayed.
Any thoughts?
--
John
...
Word 2007 TOC Not saving settings...Hi there,
When I use Word 2007 TOC, and I want to edit an existing TOC layout, etc. It
wont remember my settings.
I go to
References
Table of Contents
Insert Table of Contents
Then I make my chnages here, such as changing the levels of the various
styles and how they show up
Then I select OK, the TOC is created..
I then decide I don't like the changes I made, or I need to include another
style
So I go to
References
Table of Contents
Insert Table of Contents
The changes I made are no where to be seen. I have to start over from
scratch.
What am I doing wrong,...
Filling in Cell above with Data from belowHave data where I need to fill in A1 with A2 Data, A3 with A4 and so on:
Col A
123
XXX
345
YYY
Need it to end up like:
XXX
XXX
YYY
YYY
How can I do this?
visit www.ExcelGoodies.com If A1 and A3 are blank:
Select A1:A4. Press Ctrl+G. Click special, blank.
Start typing a formula:
=
Then press the down arrow key. This should finish the formula and create:
=A2
Press Ctrl+Enter to apply formula to all currently selected cells.
If needed, you could then do a copy, paste special - values only.
=======
If A1 and A3 are not blank, but you want every other line copie...
Encoded Word DocumentsWe have recently purchased a new pc with windows 7 and have installed the
Microsoft Office software however when I got to open a PDF or word document
from a webpage a file conversion pop up box comes up and asks for me to
select the encoding that makes the document readable but none of them do.
even the windows default doesn't work......
You cannot open a pdf in Word. You need Adobe Reader.
What you're downloading from a web page probably isn't a Word
document, either.
On May 27, 4:25=A0pm, Newuser <Newu...@discussions.microsoft.com> wrote:
> We have rece...
Data, Group got error message Cannot shift object off sheetI created a command grouping several columns together by going to Data, Group.
When I go to click on the "-" sign to group. It gives me an error
message;"Cannot shift object off sheet". Why? and how can I fix it.
Maybe you have some objects that get rearranged when you hide the columns using
your grouping symbols.
This may have some suggestions that work for you. It's kind of a similar
problem.
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769
Remember to look for comments and merged ...
Outlook 2007 Export w/ DateWe have a need to print a list of e-mails from Outlook 2007, so we can make
comments on each of them. The export seemed to be a perfect fit for this,
because we could bring it into Excel, and type our notes. However the
export does not include the date field. That's crazy. That's one of the main
pieces. Is there any way at all to export this data and include the dates?
Thanks,
Jesse
http://www.outlook-tips.net/howto/copy_data.htm - if you need the message
body, add the message field to the view and copy and paste. Note that it
works best if don't need the body - or at...
Where are my saved word?I open the attachment directly, it is .doc and edit it in a loong time, what
I ask is when I press save button and it show nothing so I think it succes.
And I close it!! I can't find it now, could you help me ????? Thanks!
It is gone. When editing an attachment, you /must/ save it to your HDD
first, edit it and then reattach it.
--
Bruce Hagen
MS-MVP [Mail]
Imperial Beach, CA
"smezsc" <smezsc@discussions.microsoft.com> wrote in message
news:3AF0D07A-D490-4819-A649-1C5FC079027F@microsoft.com...
>I open the attachment dire...
Word Wrap: Where is it in Word 2007?I have Googled and Googled and cannot find any page that tells me where
Word Wrap is. For such a basic feature you'd think it would be under
View. Suggestions?
On Mon, 18 Jan 2010 18:55:28 -0600, "Gary Gary" <blah@blah.blah>
wrote:
>I have Googled and Googled and cannot find any page that tells me where
>Word Wrap is. For such a basic feature you'd think it would be under
>View. Suggestions?
The reason you aren't finding anything is that word wrap is automatic
in Word unless you turn it off, or possibly if something is broken.
Wha...
DPM 2007 Rollup KB 979970 is now availableFolks:
The latest DPM 2007 Rollup KB 979970 is now available for download at
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=775e1a23-825f-450a-9d71-6b8c951ea748.
The KB page is available http://support.microsoft.com/kb/979970
--
Thanks
Praveen T [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights
...
Bulk E-mail with Non-Word AttachmentI need to be able to send a bulk e-mail (not from a template) with
attachments of a number of different document types to a group of contacts
(could be from a Saved View or Marketing List). Direct E-mail, Quick
Campaigns and Mail Merge do not seem to be able to do this. Is there another
way? Thanks.
Nope.
Take a look at this blog
http://groups.google.com/group/microsoft.public.crm/msg/0a84808e99645006?dmode=source&hl=en
Cheers,
Venkatesh
----
On May 16, 11:57 pm, DStella <DSte...@discussions.microsoft.com>
wrote:
> I need to be able to send a bulk e-mail (not from a tem...
MS Pub 2007I'm using MS Pub 2007 and have a question about HTML fragments.
I am attempting to insert the javascript from aWeber where a person
can subscribe to my newsletter off my website (created with Pub). How
can I set up a "submit" button in my publication with the script?
Thanks for your help.
Gary
Inserted HTML code fragments will not work in an email message from
Publisher. Sorry.
DavidF
"geedc" <geedc1@gmail.com> wrote in message
news:aff5f787-ccfe-423e-b392-66227f87c16d@r15g2000prh.googlegroups.com...
> I'm using MS Pub 2007 and have a question about HT...
Word 2007--pesky black dotted lineHello:
I have this moderately thick, black, dotted line running between paragraphs
on my page. I have no idea how to get this thing to go away. Please, could
you tell me what to do to get rid of it?
Thanks,
John Saxon
See here
http://word.mvps.org/faqs/formatting/CantGetRidOfLine.htm
--
Mary Sauer MVP
http://msauer.mvps.org/
"John" <someone@someplace.invalid> wrote in message
news:2B22C75C-4BBB-43E0-8C67-BE19C55B818C@microsoft.com...
> Hello:
>
> I have this moderately thick, black, dotted line running between paragraphs on
> my p...
Why does a spider chart add up values?I've created a spider chert from a pivot table. The spider chart should show
two spiders for two value ranges. For some reason it adds up the second value
range to the first creating too high values.
I don't want the chart to display the second value range relative to the
first, but absolute.
Can someone help me with this?
Thanks! Mark
Hi,
I don't know why it stacks the lines by default in a radar pivot-chart,
but to get to a relative type change the chart type to clustered column
and then back to radar.
Cheers
Andy
Mark wrote:
> I've created a spider chert from...