Copying charts and their data with relative cell positions
I have a chart with a data table next to it. The looks of the data table and
the chart have been modified to the look I need, however I have to repeatedly
show this same chart and data table multiple times in the same worksheet but
with different data.
What I want to do is copy the chart and it's corresponding data table and
paste into into a different location on the spreadsheet. However when I do
this the chart always keeps the original cell refernces. Apparently the
chart uses absolute referncing instead of relative referncing. When I
attempt to modify the chart's data s...Export Excel Data to Access With a Macro!!!
I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.
Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
> I have been trying to create a macro in excel to automatically export data
> into access, but to no avail. Would somebody please give me a hint?
> Your assistance ...getting tight vertical fit automatically
Is there a way to get a tight fit vertically, without having to
hand-adjust many row heights (some of three lines, some of 1, etc)?
If format|row|autofit is too "loose", then I think manually is the way to go.
> Is there a way to get a tight fit vertically, without having to
> hand-adjust many row heights (some of three lines, some of 1, etc)?
...Finding data on another worksheet in same workbook...?
I previously had data on same worksheet as formula:
and so on...
But now the data is on Worksheet named: "ItemList"
With again all the data being between B99 and B1000....
How do I now put the new worksheet into the formula above so that it will
get data from cells B99 to B1000 on worksheet named ItemList?
"David Penney" <email@example.com> wrote in message
> I previously had data on...Year End closing with master data & setup required
We are at the Year end closing, however we want to know if its feasible
to close the company, create a new with the same details in terms of setup
& master data but without any of the old transaction history and other
How can we do this is GP Utilities and is this the correct way ?
You can only create a new company using Utilities. You cannot copy any of the
To copy data from one company to another you have to use a tool like the SQL
Server Import/Export wizard or Data Transformation Services or even Microsoft
Access. There is a knowledgebase art...charting hidden data...
This is a multi-part message in MIME format.
Is there any way to have an Excel chart continue to show values when the =
source data columns or rows are hidden? I have some charts whose data =
sources I want hidden in my main spreadsheet - the only problem is that =
when the columns are hidden my charts are blank!
Thanks in advance for any help.
charset="is...Refreshing pivot table when cut/paste data
I think this is supposed to be easy, but I'm having
trouble. I have a pivot table that is run off data called
Source. I need to replace the Source data on occasion,
and so have been "cutting and pasting" the new data into
Source - it's exactly the same in terms of columns, but
has more rows. When I got to "refresh", the pivot table
says it's invalid data, or some such error, and I have to
rebuild. I think there is a way with links to do this, but
I can't find it clearly explained. Any suggestions?
Debra Dalgleish has some (lots) instructions here ...Purchase Orders
I'm trying to create POs using GP (version 8.00g34) on our GP server,
however going Transactions -> Purchasing -> Purchase Order Entry generates a
"Cannot access this form because the dictionary containing it is not loaded."
error. The other areas of GP (which I have access to) look OK.
Could there be something wrong with my Dynamics.set file? We have
workstations that use GP and the .set file looks the same.
Any advice would be greatly appreciated.
Thanks in advance,
Check to make sure there security is not looking for an alternate Great
Plains windo...Subtotal Lines in the wrong place Excel 2003
When nesting subtotals in Excel 2003, the subtotal lines are not in the
correct position. Is there a fix or a work around for this problem?
Craft Code Crew Count
BA Elec 1
BA Elec 1
BA Total 2
Elec Total 2
AFAIK you should start with the subtotal for the right-most column and
then add the other columns step by step
"k2quayle" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:FF252538...Drag and drop data only??
I am working on a very large spreadsheet and need to drag and drop large
amounts of data. The problem is that when I do this is drags and drops my
borders also, leaving the empty cells with no borders. Is there anyway that
I can drag and drop my data only?
When you drag and drop use your right mouse button instead of the left. That
will give you a menu of options. Select Copy Values Only.
> I am working on a very large spreadsheet and need to drag and drop large
> amounts of data. The p...no data echo in fields
I have two spreadsheets. On both, all of the sudden the data in the
spreadsheet cannot be seen. If I click on a cell box, the data is at the top.
I can click on the top and the cell will fill with the data. As soon as I
click another cell the data goes away.
The only change I have made is to install Crystal Reports on my computer.
Any ideas or thoughts would be very helpfull.
...storing custom resource data in text format #2
When I try to insert a resource file, I can choose among standard resource
types such as icon, bitmap, dialog, cursor and HTML.
I wish to store some SQL text. When I try to insert this as a custom
resource, it always assumes it to be binary data, which makes editing it
from within the resource editor a pain in the ...
So currently I am storing this under "HTML" type, as it is the only resource
type that lets me insert text files.
Is there some way for me to insert my own "SQL" resource type, and let the
resource editor know that this category is "text" en no...Help required to send data from one worksheet to another
I'm trying to create a spreadsheet that will be used to log details of
calls coming into a helpdesk. The spreadsheet is going to be used to
provide management information about the nature and type of calls.
I'm trying to move all data from one sheet onto another sheet in the
same workbook (sheets CLT and CS). I'm looking to transfer data from
cells L8,L10,L12,L14 on sheet CLT to sheet CS when a button is clicked.
When the button is pressed for the first time the data should record on
Sheet CS in Cells A2,C2,E2,G2, the second time the button is pressed
the data should record in ce...Email line spacing
When writing an email in MSCRM double line spacing is used. Does
anyone know of how to change this to single line spacing. At the
moment we are having to write the email in Word and then copy/paste it
into the MSCRM email.
Instead of pressing Enter, hold down Shirt button and press Enter.
"Lee" <email@example.com> wrote in message
> When writing an email in MSCRM double line spacing is used. Does
> anyone know of how to change this to single line spacing. At the
> moment ...How do I specify using lines or bars on graphs w/ 2nd value axis?
I am building a chart using a secondary axis with both the data displayed in
both bars and lines. Everytime I add a new field Excel decides if it will be
displayed as a bar or a line. How do I control that decision myself. I
understand how to align data to a secondary axis, but not how to control the
bar vs line option.
Create your chart using all lines or all bars. Select one to change, and
use Chart Type on the Chart menu to change it. Select the next to change
and use the F4 function key shortcut for Repeat Last Action. Etc.
Jon Peltier, Microsoft Excel MVP
Peltier ...The data for the search should be organized in a single contiguous range in one column.
I am new to this forum. basically looking for a macro in excel that
would match the values that are opposite and not equal and also in the
Basically the values should match and the cell highlighted.
I want that values , which are matched are highlighted. In other
world , where the sum =0, then it should match all the relevant values
and highlight's them
Note: the column should be min of 100 lines
the result should show:Highlight 250,-100,-100,-25,-25 , as there sum
Hope to see a reply soon ....
...Have duplicate rows of data
I have a database in Excel format that I need to trim down. There are
duplicate "entries", with identical information by rows. Is it possible
to have it automatically trimmed, deleting the duplicate rows?
I have 2,100 rows of data, many of which are duplicate. Just want to
trim that down...
Message posted from http://www.ExcelForum.com/
have a look at
> I have a database in Excel format that I need to trim down. There are
> duplicate "entries", with identical informat...Problem deserializing XML data with xsd.exe
I'm trying to read an xml config file in C#. To do this, I have used the
xsd.exe tool to create an xsd file from my xml, and to generate code to
read this xml file.
Here is a small sample of my xml file:
Whereas I'm able to read the directory value correctly, I cannot read the
value of name. After some searching, and after modifyin...Command Line Interface
I have a rather peculiar problem, I need to impliement a command-line style
interface into my MFC dialog program which can output, read / write strings
The thing is the functions I need to step them through are extensive, and do
need to be written in C++ function forms, in effect I need to write a
console app, within a dialog app, and have the console as part of the dialog
Does anyone have any idea's how I could impliment such an interface? I
understand this may be pretty vuage,
Read the second question in
http://msdn.microsoft.com/msdnmag/issues/04/0...How to insert one line after declaration in exsiting xml file?
Here is partial of existing xml file:
<?xml version="1.0" standalone="yes" ?>
In asp.net, how to insert one line after declaration in exsiting xml file?
<?xml version="1.0" standalone="yes" ?>
<insert new line here.......>
&...Can't transfer money data file between computers
I've tried, but failed, to transfer my money data file from my old computer
to my new computer (old is ME, new is XP). No matter what I do I keep
getting an error message "Money cannot locate [my file location and file
name] or cannot open it." I've tried to make a backup copy from my old
computer, and open this with the "restore backup" feature, but got the above
message. Anyone have any ideas or suggestions? Thanks
In microsoft.public.money, Mark047 wrote:
>I've tried, but failed, to transfer my money data file from my old computer
>to my new...Summarization of Excel data
I need to summarize (subtotal) rows in an Excel spreadsheet. The subtotal command gets me part of the way there, but I need more functionality. I have 1000 records that I want to subtotal amount by customer number. But, I also need the customer name, address, record count, etc. in the subtotal record. I would like to be able to use an sql statement to do it, but don't know if possible. Any ideas?
I don't know, but it sound like a job for a pivot table to
me. As long as your dataset isn't dreadfully huge, I
think it would do the trick.
Try DATA, SUBTOTAL
This will m...On Line Stmt Balances Different than Account List Balances
I just migrated my money files from an old pc to my new
pc by backing up the files on a diskette and then opening
the backup diskette on my new pc. I then downloaded
about a one week of transactions from my bank and credit
cards; however the balances reflected on the "Read Online
Statments" screen are different than the "Account List"
balances, and the "Read online" balances appear to be the
correct balances and agree with the balances on the
I just had a very similar problem. I had downloaded
transactions on my old PC and ha...newbie needs examples of creating a recordset and inserting data using it in Access 2007?
I have created a Access 2007 database, Test.mdb, created a table called
"mytest" and created required fields in it. Now, using VBA(Visual Basic
for Applications) I want to insert data into it using a Recordset from a
Can anyone please point me to a proper link where there is an example of
how data is inserted using a Recordset into a Access 2007 table?
I created one using resources on Web, but it is not correct.
Dim cnn1 As ADODB.Connection
Set cnn1 = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myReco...Automatically highlight certain data.
I have a spreadsheet with a schedule of duties that are done every Sunday.
Different people are assigned each week for each duty.
Sunday, May 2
Greeters Mr. x
Ushers Mrs. y
Counters Ms. z
It's a vey long list and a very large spreadsheet (covers several years of
I'd like to be able to highlight/change letter color for the Sunday list
that has the info for the upcoming Sunday. I've been trying to figure it
with 'Conditional Formatting' but there must be a calculation, or something,
to figure out h...