ASP.NET, SQL Server, WPF, C#, VB.NET

Morning All 
 
There's a set of Excel utilities called ASAP which I find extremely useful 
 
http://www.asap-utilities.com/ 
 
Does anyone know of similiar/difference sets? 
 
Cheers 
 
CO

Howdy All, 
 
I used to create tab delimited text file from data in my spreadsheet, but i 
 
now need to save it into xml, 
 
for example, lets say ive got a sheet with 10 listings, (rows) and each 
 
listing has 6 fields (cols) below 
 
Name 
 
ID 
 
Location 
 
Date 
 
Value 
 
Info 
 
How can I save this to a standard xml file so that it will work in other 
 
applications? 
 
Using Excel 2003

When I installed Office 2003, a total of 288,981K of "Office Setup 
 
Files" appeared on my hard drive the first time I did a scan disk 
 
cleanup.  Is this where the Office Setup Files belong?  Is their 
 
presence there slowing the performance of my computer?  If these files 
 
belong somewhere else, where would that be? 
 
Many thanks from a first time user. 
 
JJ  :confused: 
 
+-------------------------------------------------------------------+ 
 
|Filename: Office Setup Files.JPG          ...

newbie here:) 
 
I would like to have a cell recognize if its formulated value is larger 
 
than another cell's formulated value.  And if it is, make text bold. 
 
any help is appreciated, 
 
mahalo, 
 
danny 
 
-- 
 
daniel@hawaii 
 
------------------------------------------------------------------------ 
 
daniel@hawaii's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36267 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=560543

I have an invoice with gridlines turned on, preview looks good, printed 
 
output looks good, but when I email it some of the gridlines are black 
 
rather than grey. I cant seem to make any of them change color they all stay 
 
on automatic, unless I use format cells on the toolbar, then only some of 
 
the cells change color. 
 
Any Ideas? 
 
Thanks 
 
Dave

Hi there 
 
I have the following cmdOK button for a form. 
 
Private Sub cmdOK_Click() 
 
Sheets("Band Members").Select 
 
Range("Last_Name").Select 
 
Selection.EntireRow.Insert 
 
ActiveCell.Value = txtName.Text 
 
ActiveCell.Offset(0, 1).Value = txtAddress.Text 
 
ActiveCell.Offset(0, 2).Value = txtSuburb.Text 
 
ActiveCell.Offset(0, 3).Value = txtPhone.Text 
 
ActiveCell.Offset(0, 4).Value = cboType.Text 
 
ActiveCell.Offset(0, 5).Value = "A" 
 
ActiveCell.Offset(0, 6).Formula = "=IF(Status  ...

Hi, 
 
I have some data arrnaged this way: 
 
Name    Subject   Grade 
 
Peter     Math         A 
 
Peter     English      B 
 
Peter     Science      C 
 
Sally      English      A 
 
Sally      Math          D 
 
How can i re-arrange them to give a crosstab them this in excel? 
 
Name  English   Math  Science 
 
Peter      A            B        C 
 
Sally       A            D 
 
etc? 
 
I tried Pivot tables but that only seem to give you the count. 
 
Hope you can help.

Is it possible to automatically run a  macro if a cell contains a certain 
 
value??? 
 
thanks 
 
Rossella

My first two rows in my spreadsheed is my header. How do I make this 
 
header stationary while I scroll? 
 
-- 
 
keepers5 
 
------------------------------------------------------------------------ 
 
keepers5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36250 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=560448

Hi, 
 
I've used excel in its simplist form for a while now, however just 
 
recently I've attempted to make something clearly beyond my skill level 
 
Ive displayed below a flowsheet of what Im trying to achieve 
 
'[image: http://images6.theimagehosting.com/Excelsheet.JPG]' 
 
(http://www.theimagehosting.com) 
 
Currently the below is what I've done, This takes into account only the 
 
first instruction excluding the part where it verifies if the sum = a 
 
specific amount and if its less, it  ...

I am attempting to re-work an existing worksheet that contains cells 
 
that have been "named".  Does anyone know how to change or delete a 
 
name once entered into the "Name Box"?  When I attempt to write over 
 
the names, I receive and error message regarding references.  Thank 
 
you. 
 
-- 
 
tbryson 
 
------------------------------------------------------------------------ 
 
tbryson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36246 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=560418

Hello, 
 
I am new to the forum, and have what I expect to be a rather simple 
 
question to answer. 
 
I work with several excel worksheets that are prefilled with default 
 
information, and have blanks spots for new information to be added so 
 
that I can print or send the file to a client so they can print it.  I 
 
am worried that when I am sending the worksheet, they can modify the 
 
information on the sheet - just as simply as I did.  Considering this 
 
would put my job at risk if anyo ...

hi all, 
 
does anyone know how to save data coming form formulaarray directly to 
 
a variable?

I have a list of Business names with their Address locations directly in the cell below, i.e. 
 
Business Name 
 
Address 
 
Business Name 
 
Address 
 
Business Name 
 
Address 
 
Business Name 
 
Address 
 
Business Name 
 
Address 
 
I have tried to make a macro that will move each Address from the cell below to the next cell directly to the right of the 
 
appropriate Business Name, i.e. 
 
Business Name | Address 
 
<blank row> 
 
Business Name | Address 
 
<blank row> 
 
Business Nam ...

I have a large workbook with two types of sheets.  One type has detailed 
 
info. and is always named after a five-figit number.  The summary pages 
 
are titled things like "summary" or "overview".  I have around 100 
 
detail pages and about 15 summary pages. 
 
1.  I need to build an array of sheet names that meet the criteria of 
 
having a five-digit number for their name. 
 
2.  I need to print that array in a list on one of the summary pages 
 
starting in cell b15 in ascending order. 
 
 ...

Hi! 
 
New soft for a cheap price at our online store! 
 
'3DALiENS GLU3D 1.3.13 FOR MAYA 7.0' 
 
(http://tender.masterbell.net/index.php?target=price) 
 
Thanks! 
 
-- 
 
tenderxmusa 
 
------------------------------------------------------------------------ 
 
tenderxmusa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36244 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=560198

I've got a column full of numbers like 0.5, 1.0, etc. I need them to look 
 
like 0.500%. I figured out how to format the cells so that 0.5 looks like 
 
0.500, but when I change the cell format to percentage, it makes 0.500 into 
 
50.000%. 
 
So I figured out how to make a formula that divides 0.500 by 100 
 
(=R1C6/100), resulting in 0.005, which I can format to a percentage and get 
 
0.500%. 
 
Where I'm stumped is in applying that formula to the entire column. Instead 
 
of =R1C6/100, I wa ...

Hey there, 
 
in cell A2 I have a time, say 07:00 hrs. In B1 in have i.e. 3 minutes of 
 
time an operation takes. Now I want to add those 3 minutes to the time in 
 
A2, so I have 07:03 hrs in cell B2 
 
How do I have to format the cells to get that done? 
 
Thanx well in advance! 
 
Jochen

HIYA 
 
-- 
 
\m/ O_O \m/ 
 
Laura.....  :) 
 
Liverpool, England

Hi again ! 
 
Another simply one I hope: 
 
I have 2 columns of data 
 
Country	            Band 
 
UK	            A 
 
GERMANY            B 
 
ITALY	            B 
 
FRANCE	            D 
 
SWEDEN	            D 
 
DENMARK	            E 
 
Is there a way I can show the data via colums ie 
 
Band 
 
A              B             C              D                E 
 
UK            Germany                   France         Denmark 
 
Italy                         Sweden 
 
BR 
 
Simon 
 
-- 
 
spgpriv ...

Good day, 
 
I was wondering if any one could help me with a problem. 
 
My column A contains dates in a dd-mmm-yy format.  Column C contains a 
 
number of events that took place. I am trying to count the number of 
 
events in a fiscal year. 
 
A...................C 
 
01-Jan-05..........1 
 
02-Feb-05.........1 
 
03-Mar-06.........1 
 
11-Apr-06.........1 
 
09-May-06.........1 
 
11-Jun-06..........1 
 
=SUMPRODUCT(--(activity!C2:C1000),--(YEAR(activity!A2:A1000)=2006)) 
 
Will count the ev ...

Here is what I have 
 
$130.39 
 
$52.90 CR 
 
$16.00 
 
$84.32 
 
$20.00 CR 
 
I would like to be able to get the sum of these numbers, but the numbers 
 
with a CR(credit) by it I would like to subtract from the total. So the 
 
total would be $157.81. The dollar amount and the CR's are in differnt 
 
columns. 
 
thanks

When I open Excel and click the 'File' menu item, a drop-down list of most 
 
recently used files appears, as is normal in Windows programs. In Excel 
 
however the list is usually wrong. It usually omits the files which I have 
 
used most recently and lists only ones which I used some time previously. 
 
The problem never happens in other Windows programs. Is this a peculiarity 
 
of Excel? and is there a fix for it? 
 
Windows XP Pro, Excel 2000. 
 
John

Can I make the font of a certain cell change it's font colour to Red if 
 
the word in the cell is, example, "Fail"? I want the change to apply 
 
from B2:F23. 
 
-- 
 
wuming79 
 
------------------------------------------------------------------------ 
 
wuming79's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36037 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=560169

I have a main workbook containing 1000 rows & 15 columns. 
 
I wish to use pivot table to extract some columns based on criterias, 
 
such as: 
 
Region = WEST 
 
CreationMonth = a cell located in an other workbook 
 
(workbook_config!$a$4 which contains 05) 
 
Ordereditem = "bikes" AND "wheels" AND "skate" 
 
Is this feasible using pivottable? The top would be to allow end user 
 
to manually 
 
Thansk for your help, 
 
Celua