how can I format output data to a file
How can I format data for output to a file in a particular
format ie. 6 chars 25 chars 49 chars from 3 work sheet
columns which a not 2,25 and 49 long. This is so that the
data can be read by another program. If the first cell
only has a "1" in it how do I get excel to output blanks
to fill the space to 6 char for the first output?
Set your column widths to the field widths you want (6, 25, 49). Set the
text alignment for each column to what you want if the default (left for
text and right for numbers) is not correct.
Then do a File, Save As and pick Formatted Text as the f...Deleting data entries but not formats
I have some trouble with excel... and with a document which I use for serial
mails via Mail Merge. Now I need to clean all old data entries and prepare it
for the next use. But if I simply delete the entries or do it via
Clear-Entries then I have problems because conditional formatting will also
be deleted and furthermore the mail merge cant work anymore because some
fields are not found anymore. Does someone know how I can only delete the
data entries, nothing else? The Mail merge runs via SQL and I'm not quite
good in it...
Thanks a lot in advance and a nice weeken...How do I fit a graph to data?
I work at a non-profit agency. We receive funds on an annual basis for our
work, which we distribute under contract to other agencies. The full details
aren't important, the main point is the rate of "burn" through the money. We
use different mechanisms to ensure that it lasts throughout the fiscal year,
such as breaking it up into smaller chucks, etc. I watch the burn rate to
see how it is going. I record this on a daily basis in an Excel spreadsheet.
Due to business practices with the other agencies, the burn rate isn't a
simple linear graph with a negative slo...Requery / Refresh calculated texbox
On a form I have two textboxes (cbo1 and cbo2).
I need to have a formula in cbo2 (eg [cbo1]*10, that will use what I type in
The problem is that I need by changing the value in cbo1, immediately to
have the result in cbo2.
e.g. I type 1 in cob1 = 10 will be shown in cbo2,
by typing more in cob1, e.g. 11, in cbo2 will be shown 110.
This should be done before update? Where shall I use the requery method?
Thanking you in advance,
You can do this one of two ways:
Private Sub cbo1_AfterUpdate()
Me.cbo2 = Me.cbo1 * 10
set the Control Sou...Pivot Chart Refresh cancels all chart formatting
I am using pivot chart with calculated fields, on which I did some quite
sophisticated formatting (combination chart stacked bar / dot plot with
secondary axis ; bar & plot area & grid colors ; labels ; axis & chart
When I click the "refresh" (!) button to update the data, the chart
formatting is lost and the chart reverts to the default formatting (stacked
bar chart with all series)
Is there any way to "memorize" the chart formatting on a pivot chart ?
Loss of formatting is a known problem with pivot charts. There's
inf...adding new columns sheet with external data
I have a excel sheet that I import data from a external database and then i
added columns to the sheet that have entries made by me. When the data
refreshes if the data is no longer coming from the external it leaves the
data that i entered still there. I want it to delete the whole row and leave
no data at all external or internal for that line that now does not exist can
this be done?
...Help with a formula to determine data presence in other worksheets in the same workbook
I have a workbook with 20+ worksheets in it. Each worksheet contains a
series of columns where generally the 'key' (not a real key but the
term will suffice for this example) is in the first column and various
attributes of that key exist in subsequent columns.
I have a summary sheet as the first one and what I want is a base
formula that will tell me if the value I'm looking for exists in a
target worksheet (the 'key' column) and if it does, does the value in
one of the subsequent 'value' columns match some pattern.
I have searched around but I don't really ...Populating XML data
Hi Guys, I'm fairly new to Powershell (and XML) and have come across a
stumbling block that I can't resolve.
I'm trying to write some code to poulate an XML file with data about
sites within our organisation. This issue is with the nested nodes (I
think they're called nodes?)
The XML which I hand wrote looks like this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<State>VIC</State>...Import data from the web
I am trying to import large amounts of data from the web
onto a spreadsheet. After about 200 updates, I start
getting an error message that indicates the site and then
informs me that "the connection to this internet site took
longer than the allotted time". I assume this is because
I am hitting the site too many times in a few minutes. IS
there any way to fix this? Can I put some sort of spacing
line into the spreadsheet so that it gives the site a
take a look at ENBLEEVENTS
Granite Shoals, TX
"mi...How do I get rid of/refresh the browsed pages links in the hyperli
It's driving me nuts just to find one link. Ig I could clear it up once in a
while that would be cool. thanks for the help. :)
In Internet Explorer, tools, Internet Options, delete files.
Mary Sauer MSFT MVP
"adumbledore" <email@example.com> wrote in message
> It's driving me nuts just to find one link. Ig I could clear it up once in a
> while that would be cool. thanks for the help. :)
...Graph Data Values
I am trying to create a pick and mix graph that shows forecast spen
against actual spend by a selected business area.
I somehow want to create a graph on the fly based on the selections fo
If I choose company one and want to see the contracted data I want th
graph to pick up the forcasted contracted Labour, Passthru and Othe
and show the combined contracted actuals; See attached;
and if i then choose company 2 then graph will pick up the releven
Attachment filename: help.zip
Download attachment: http://www.excelforum.com/attachmen...Error when trying to save data
This is a new CRM install on a Windows 2003 server. The problem is an error
whenever we try to save any data.
When checking from the server looks like this:
Server Error in '/' Application.
A potentially dangerous Request.Form value was detected from the client
Description: Request Validation has detected a potentially dangerous client
Can someone please send out the fix information "In detail" including links,
and locations of files?
Microsoft CRM is not designed to run on server 2003. ...Filling cells with Serial Port Data
Anyone know how I would go about filling Excel spreadsheet cells with data
from the serial port?
"Funster" <firstname.lastname@example.org> wrote in
> Anyone know how I would go about filling Excel spreadsheet cells with
> data from the serial port?
probably one of the first results on
will tell you what you want
My email address has an extra @ (spell it out) and an extra invalid. Please
remove them if you are not a spammer or list broker and ...Excel 2007, Sort data by no. similar entries?
Is it possible with Excel 2007 to sort data by the number of similar entries
within a column?
What I want to be able to do is sort data in Row2 so that Rachel shows 1st
as she has 3 entries, then Andrew and finally John as he only has a single
instance, is this possible?
How about using a helper column? I read your row1 as column1 and row2 as
column2, and put the formula like "=COUNTIF(B$1:B$6,B1)" into C1 and
copy it down to C6. then , sort the table b...How to Select large amount of data in a colum that equals column from another table.
Ive got a huge table and I want to select the data in one column that is
equal to that of a column in another table?
is there an easy way to do this?
One way, if you know the parameters of the original, is to type the
references in the name box and hit <Enter>.
For example, click in the name box and enter:
Please keep all correspondence within the Group, so all may benefit!
"Jennifer Burnel" <email@example.com> wro...adding lines to added data
I have added data to an existing worksheet but when
printed the row lines and column border lines do not
show. How do I add the lines to the added border to
match the existing lines?
...Insert sheet, move to end, rename with cell data.
I've spent most of my day trying to ask VB to do this for me, but don't
know how to communicate it correctly.
I have column A in "List"(Sheet1) with 150 entries.
I want to create 150 sheets with Sheet numbers of 2-151.
However, I would like for the tabs to read what the appropiate cell in
was my column, I would like the first four tabs to read "List" (my
original sheet), "Fun", "Not Fun", and "Cool".
Then they would appear in Microsoft Visual Basic as Sheet1(List...vlookup help linking data between worksheet
I have a master list of students (about 200+ )in one worksheet. On the
succeeding worksheets are the attendance for seminars. We have more than 20
seminars in a year. Because of the large no of attendees per seminar, I
usually type out a list of the students who came for each seminar, so there
will be 20 +attendance worksheets.
Not all students will come every time and there are new ones for each session.
To update on master list, I will sort each sheet by surname, print it out and
type in separate column (date) for each session and typed "P" for present
and &quo...How do I chart the same data cell on a range of worksheets?
I have the same row of cells on numerous worksheets that I want to chart or
consolidate onto another worksheet ?
You need to create a consolidated data range:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have the same row of cells on numerous worksheets that I want to chart or
> consolidate onto another worksheet ?
...Dynamic range (column); include only rows before blank row above more data
One worksheet will contain more than one table holding lookup values
(prices, CPU speed, etc.). They will be located one on top of another, with
possibly some other data between tables, separated by at least one blank
row. They will be expandable by row, as new prices, CPUs, etc. are added.
I want the range name to expand and reflect all the rows in a table.
Using a column as an example of tables,
a (in A1)
represent 2 tables (ranges).
Excel Hacks has the code for Define Name "Refers to" as
=OFFSET(Sheet1!$A$1,0,0,MATCH("*",Sheet1!$A$1:$A$100,-1...Export data to txt format file
Can I write a VB procedure that will export a table of data with specific
widths? I done it manually, but no success with VB procedure
On Thu, 3 Dec 2009 19:36:01 -0800, paduanow <firstname.lastname@example.org> wrote:
>Can I write a VB procedure that will export a table of data with specific
>widths? I done it manually, but no success with VB procedure
Take a look at the Help for "TransferText". Yes, you can create an output
specification with fixed width files, in code just as you can using File...
John W. Vinson [MVP]
...Accountextensionbase missing data ? Help
I have a customer who has moved CRM 3.0 to new server by them self and I
have converted it to CRM 4.0
Now they have made some custom fields and we are able to save data in these
fields on new accounts but not on the old ones.
We can save data in the old fields.
I then took a look at the database and there is only fields in the
accountextensionsbase since after they moved the database.
How can I fix this ? They can merge each to a new customer but that would
take a long time.
Can I do a insert into with data from the Account table or is there another
...Export Data from MS-CRM
Is there a way to export all of the data from MS-CRM?
Thats a rather general question,......you mean export to another CRM system
or just export into another medium?
For the most part, most areas have that little excel icon so that you can
export into excel......
or you can go into the SQL server and use the export wizard, although I
don't think its going to be what you want,....for the most part it will be
raw data and you'll have to recreate the relationships and primary fields to
see how the objects relate..........
"John O'Keefe" <email@example.com...Why does the pivot table not allow me to group data?
I need to group the data in a pivot table, why will it not allow me to?
If the field in the source data contains blank cells, or cells with
text, you won't be able to group the data. There are some suggestions
here for fixing the problem:
> I need to group the data in a pivot table, why will it not allow me to?
Excel FAQ, Tips & Book List
The tip did not help however, since you wrote the book, literally, let me
explain what I need to do. I need ...Why is the data pulled down from an online update, ALL WRONG?
I'm using Money 2004 Deluxe. I just figured out how to get online updates
for my 403(b) from Fidelity. I've pull everything down into MS Money.
Looked cool, at least for a while.
Then I noticed that out of the 6 mutual funds I'm investing in, only 2 had
symbols associated with them. So I tried to assign the symbols to the other
4. Only thing is when I did, I got error messages saying that the symbol
was already in use.
So then I went into help and found that if I went to the Investing menu
option and choose "Work With Investments" and then choose "Choose ...