|
Copying XML data to Word
I have got an Excel XML spreadsheet which grabs data from Microsoft
CRM. I have set it up to have 5 different sheets.
I want to copy information from each of these sheets into Word, but for
some reason, only data from the first sheet is copied. When I try to
copy cells from other sheets, I get blank cells in Word.
Can anyone tell me why?
And even better, is there an automatic way to copy t...
|
1 |
08.09.2006 05:35:51 |
|
|
Need help with finding closest match
Hi,
I have a spreadsheet where I have 3 columns of numbers in A, B, and C,
(skipping column D for clarity sake). In column A there are subgroups
of numbers in tenth increments until they get to the next subgroup.
However, if you truncate the column A numbers you would have 3 rows
starting with 1, 2 rows starting with 2, 5 rows starting with 3, 3 rows
starting with 4 and 1 row starting wit...
|
1 |
08.09.2006 02:27:35 |
|
|
Automatic Stock Quotes?
G'day
Just wondering if there is any way of getting up to date stock prices
automatically downloaded into excel spreadsheets?
It would save a hell of a lot of time (currently typing them all in)
Cheers :)
B1.
...
|
3 |
08.09.2006 02:11:01 |
|
|
problem with losing control of a worksheet
I am completely flabbergasted; I am editing a worksheet which is 1/5th
what it used to be - comparing two databases which are somewhat out of
control.
If two lines match exactly, I delete them, if two lines exist but do not
match, I correct the database and delete them, and if there is an
orphan, I hide it, with the intent of going back to match them against
other databases.
Now I ...
|
4 |
08.09.2006 02:00:11 |
|
|
Use ROUND within custom function
I created a function to calc the % of markup, it works just fin until I
get into prices >99.99, and then it doesn't match to some current data
I'm using that I think is rounding. Have I built this function
properly? and if so how do I get it to round?
Function Markup(Price)
'Low to High price range * % + flat additional amount
If Price <= 9.99 Then Markup = Price * (400 / 100 +...
|
3 |
07.09.2006 23:45:28 |
|
|
Adding (Sum of) Hours...
I'm sorry to ask such a seemingly trivial (!) question here..
I *have* Googled and XL Helped but cannot get this to work and I'm on a
tight timeframe.
I'm trying to add a simple column of hours (hh:mm) worked but simply can't
find the right combination of cell formatting to give a straight answer!
The hours are actually in non-adjacent cells (a3:c3:e3 etc) but if I can get
a column addi...
|
7 |
07.09.2006 22:41:53 |
|
|
Stopping VBA code when it hits the last row
I have a list of data the is in 4 columns, and the number of rows will vary
from week to week.. Columns A-C are filled with data, and Column D will only
have data in certain cells (ie, row 6 could have a value and then the next
row to have a value could be row 20...and this value may or may not be
different than the value in row 6). I am trying to wrote code that will fill
in the blank...
|
8 |
07.09.2006 20:07:51 |
|
|
Decision Tree style logic in Excel
Hello,
Anyone can give me some advice on a decision tree style presentation in
XL? I want to do a survey which is to guide the user to a proper
result. Since I have already had all the tree structure, the only thing
I have to do is input the tree structure, and let the program keep
asking user, and then guide them to the leaves of the tree...
Many thanks.
Leon
...
|
2 |
07.09.2006 19:00:02 |
|
|
Date some qualifies
Ok, I need help with a formula (if you have time). If I have someone’s hire
date and birth date, I need to calculate what date they will qualify for
retirement, either equals age 60 plus years of service = 75 or age 65
(whichever is earlier). Thanks!!...
|
3 |
07.09.2006 18:01:02 |
|
|
Create Excel03 SS Showing Principal + Income - Payments
I am trying to create a ss in Excel 2003 showing an IRA account that is
earning 5%/pa from which I would withdraw 3% of the combined principal and
income a year. I would like to show year by year what the income will be,
annual withdrawals, and remaining balance at the end of each year.
Thanks in Advance...
|
3 |
07.09.2006 17:53:22 |
|
|
double click event for a cell in a worksheet
Hi all,
can anybody help me ?
I want a VBA code to run after double/single click on a cell of a
worksheet.
eg. after double/single click on a cell a msgbox will appear with the
sum of two other cell values.Please help me how to write this VBA code
in excell.
--
sdebu_2000
------------------------------------------------------------------------
sdebu_2000's Profile: http://www.officehelp.in/...
|
3 |
07.09.2006 17:46:34 |
|
|
gather information from another sheet with one related value
I have a workbook with two worksheets. Each sheet is getting it's data from
a different source. Sheet 3 was exported from access and sheet two is from
another workbook. There is one value (per record) that relates the 2 sheets
and I need to bring information from the related value row to the second
sheet.
I have: =MATCH(B3,Sheet3!A:A,0) In cell M3 of sheet 2, this has given me
the ro...
|
5 |
07.09.2006 17:03:02 |
|
|
ASCII text file import more than 65536 entries
Hello:
I have used this macro to import the ASCII text file in excel. It is
importing everything in the column A. I need to divide that into
multiple columns as the normal import does. Can someone suggest a quick
way of doing this?
Sub LargeFileImport()
'Dimension Variables
Dim ResultStr As String
Dim FileName As String
Dim FileNum As Integer
Dim Counter As Double
'Ask User for File'...
|
5 |
07.09.2006 16:40:08 |
|
|
Loading Data into Multiple sheets in 1 book
Hi All
I have 2 questions
1. I am trying to automatically create a workbook with a number of
sheets in it with different data. I see how the command mode allows you
to feed data to a (one/first) sheet (C:\Program Files\Microsoft
Office\Office\excel.exe" H:\':DETAIL.XFER.SHORT.FILENAME) but how do
you get data to sheets 2 3 4 etc in the workbook?
2. Can you format the data going into th...
|
1 |
07.09.2006 14:37:51 |
|
|
Relatively referencing a worksheet from another worksheet
I've been having this problem with a bunch of Excel documents in
various folder. Now all worksheets reside in the same folder but at
different level going no more than two levels in. However every
worksheet more than one level up references one worksheet at the folder
root. This is where all the folders draw their core values from.
There are about 30 or more worksheets that draw their va...
|
1 |
07.09.2006 13:57:44 |
|
|
Creating A Breakout List from a Summary List
I have a summary list that is the first input on a page that I need to
then list out in individual rows. For example:
Turn this..
Description Total Price per Unit
Unit 1 3 $3.00
Unit 2 2 $2.50
Unit 3 2 $1.25
Into this....
Descrip...
|
2 |
07.09.2006 13:00:24 |
|
|
Error
I am using ms office 2003. the excel always show a error message saying that
excel has encountered problem whenever i want to do anything with the
printing options and also when i want to bold the text in the sheet....
|
2 |
07.09.2006 11:59:20 |
|
|
cell in row has highest value and rtrns col hdr
hi,
can anyone advise as to which formula would be able to find the highest
("=MAX(A$:T$)")value in a row of cells and once identified return the column
header? thanks for any help!
...
|
12 |
07.09.2006 02:00:20 |
|
|
How to mix up digits into a new number?
I can put single digits into separate columns and concatenate them into one
number. Is there a worksheet function or formula that will randomly mix up
those same digits into a different concatenated numbers? EX: turning "123"
into "231"?
Ed
...
|
4 |
07.09.2006 00:27:35 |
|
|
Formula reference to a cell instead of inputing
Hi.
I need the following formula to point to cell (I.e. A3) for the name
(John Doe) instead of me putting the
name itself.
Any advice?
=IF(ISERROR(CELL("address",INDIRECT("'John Doe'!k37"))),"
",INDIRECT("'John Doe'!k37"))
Thanx.
...
|
3 |
06.09.2006 22:49:29 |
|
|
Amazing 40% rule
Hello All,
I have recently come across a statement called " The Amazing 40% rule" in
excel, tried to search in google, but got no information on this yet...
Can anyone help me to understand this? May be a link to the site where its
explained in detail?
Thanks
Regards
Sri...
|
9 |
06.09.2006 21:53:04 |
|
|
Preserving lock on cells even when copied and pasted within a sheet
(Sorry for repeating this post from another group; I inadvertently
neglected adding both groups in my original post in
microsoft.public.excel.misc. In any case, I found a couple of minor
errors and omissions that I have corrected :-P.)
Hi,
I am trying to create a *protected* worksheet that is flexible enough
so that additional rows can be created (by copying existing rows from
above) i...
|
5 |
06.09.2006 21:12:52 |
|
|
Is it possible to...
export 1 or more macros automaticlly tather manually? Thanks
...
|
2 |
06.09.2006 20:52:04 |
|
|
collect data from the same row in multiple spreadsheets
I have 140 employees with a separate workbook for each.The workbooks contains
their by-weekly timesheets. Each workbook has 26 sheets (one for each pay
period).
I need to start a workbook that will contain the total line for each
employee (line 37). For instance, The first sheet in each workbook in named
"july 3". I need to collect line 37 from each July 3 sheet (total 140 lines)
a...
|
3 |
06.09.2006 20:30:02 |
|
|
summing cells based on "like" value and cell color
Is there a way to look at a column and if the cell begins with
01,02,03....98 and the cell color is either yellow or pink to sum those
just those cells?
So what I'd like to do is sum all the cells starting with 01 that the
cell background is yellow,
then sum all the cells starting with 01 that the cell background is
pink?
Any help would be greatly appreciated.
...
|
8 |
06.09.2006 19:30:51 |