VBA and researching data thru 20.000 records
Hi,
I have 2 sheets with several fields.
on sheet1, i have new data and on sheet2 i have old data.
i would like to update 2 fields of sheet1 with data from sheet2.
for that i want to compare 3 fields, let's say C, D, E.
if C, D, E are equal on sheet1 and sheet2, so i want to copy data from
fields A and B (from sheet2) to fields A and B of sheet1.
for now i use selection.autofilter .....
on the 3 fields to compare, but with my 20,000 records, it's really slow
(on 3.1 Ghz CPU and 1 Ghz ram).
So i would like to know if exists another way how to do it and for sure
faster ?
thanka a lot for help.
maileen Tag: Text it two rows Tag: 86481
Windows In Taskbar Inconsistencies
Just a little rant about the weird, highly disconcerting document switching
inconsistencies between Office apps. I would have thought this would have
been corrected in Office 2003. Sadly, it was not.
Here are the inconsistencies:
Word - No problem here. It's SDI done right. Each document is its own
window. I'm actually not a huge fan of SDI but Word works well, elegantly,
and is consistent.
Excel - Fake SDI using MDI done BADLY. All your documents show up on the
taskbar making you THINK they're all their own distinct window. But, if you
click the X in the top of one of them, ALL your documents close! I hate
that.
PowerPoint - Almost Same as Excel but Different. Same weird "Windows in
Taskbar" navigation like Excel... but at least here when you click on the X
in the of the PowerPoint window, only the CURRENT document closes. That's a
bit more intuitive.
I understand that there were technical reasons for why they couldn't
duplicate their achievements with Word. But, still, why do Excel and
PowerPoint behave different even from each other??? It's highly confusing.
Whatever happened to consistency? I never hated Classic MDI, but I do see
why it has become deprecated (I prefer TDI like in FrontPage 2003 and Visual
Studio.NET). All I'm saying is that the *inconsistent* and weird behavior
between Office apps says a little about MS's attention to detail as of late.
Someone in Quality Assurance was asleep when they put out Office 2003.
--
-C. Moya
www.cmoya.com Tag: Text it two rows Tag: 86479
Auto Paste Items from the clipboard
Hi there!
i am trying to write a macro or c# app. that will use items from excel
clipboard and paste them to different sheets.
anyone has any idea how to do this?
thanks
nn Tag: Text it two rows Tag: 86464
Multiple accessing of a spreadsheet
Hey people,
My problem is that I ahve an excel file that both my collegue and
myself need to update constantly, however the problem is that in order
for me to access it and update it he needs to get out of it and vice
versa. Is there any way Excel would allow us to access it toegther and
update it together, without one of u having to come out of it.
Thanks Tag: Text it two rows Tag: 86460
Updating Links Option
When I get the message "This workbook contains links to other data sources"
I can't imagine what "other data" they are referring to. How can I find out
the source of this "other data"
Thanks in advance
Dave Tag: Text it two rows Tag: 86453
Column Size
I hope this is possible to do, if it is I don't know how to do it.
have text at top of column A and I have more below. So it all lines u
correctly, I need the top of column A to be wider than other parts. I
this is possible to do, please let me know.Also If there is anothe
option, please let me know. Thanks in advance
--
jmurrrd
-----------------------------------------------------------------------
jmurrrda's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3192
View this thread: http://www.excelforum.com/showthread.php?threadid=51651 Tag: Text it two rows Tag: 86451
Webpage
I have a spreadsheet of properties for sale that includes new and old
listings along with features that span 5 columns. I want to make this
spreadsheet available to all my clients so that they could search for
property within their price range.
Any suggestions would be greatly appreciated.
Best Regards,
EMoorhead
http://www.estandardtime.com Tag: Text it two rows Tag: 86447
Column to a row
I have a column of numbers. How do I transfer this column to a row? There
must be a function that will allow it.
Thanks,
Sal and Eileen Tag: Text it two rows Tag: 86440
formula question
Sorry for the annoying newbie test posts prior to this. I usually
just lurk but I've got an Excel problem that is bugging me to
distraction. ...this is my second post to the group on this issue, I
waited 24 hours for the first to appear and it never seemed to make
it. Anyways, here goes:
Imagine, if you will, the following 4 grids of text in columns
C1...C4:
AWRT Announces Rehr To Keynote
2006/02/23 ... Television has
http://www.radioink.com/... - 78%
Result found by: MSNBC
Directly to the column to the right you want to construct a formula
that does the following:
If C2 begins with "2006", D2's formula returns to Grid D2 the 10
characters "2006/02/23". If C2 does NOT begin with "2006" it returns
the 10 characters in the Grid immediately above that grid (that is,
C1).
...so in the case shown above, the values for D2..D4 would be:
2006/02/23
2006/02/23
http://www
...I've tried all sorts of formulas with imbedded "=IF functions" but
have not hit on the golden hind as yet.
Any help would be greatly appreciated, this will save me 30 minutes
every day.
All the best,
- Hugh - Tag: Text it two rows Tag: 86438
Muhammad: Who is He?!
here you'll find the answer
direct link
http://www.islamway.com/mohammad/?lang=eng
or doc files
http://s49.yousendit.com/d.aspx?id=...RH2LYOXWDMUK4VP
http://www.megaupload.com/?d=61T44D89
--
i_am_free5565
------------------------------------------------------------------------
i_am_free5565's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31918
View this thread: http://www.excelforum.com/showthread.php?threadid=516468 Tag: Text it two rows Tag: 86434
1:N mapping
I want to establish multiple mappings between an item (represented by a
row in one worksheet) with values within an array on another worksheet
in a way that I can iterate through the arbitarily long list of values
(mappings). So, I'm thinking that I might enter a comma-separated list
of array values into a single cell on the item's row. Is there a
function that will provide access to the comma-separated values with
which I can then use the LOOKUP function to access the corresponding
value in the array? Or perhaps there a better solution?
TIA,
David Tag: Text it two rows Tag: 86433
Range resize not working
Greetings,
I wrote the following code to automatically resize a worksheet range that
grows vertically.
With Range("RegionWorkingData").Resize(1, 1)
.Parent.Range(.Item(1), .Parent.Cells(Rows.Count, .Column) _
.End(xlUp)).Name = "RegionWorkingData"
End With
I can't seem to get it to work. When I run it I get the error message that
the Method 'Range of object'_Global' failer.
Can some one help me fix this code?
Thanks in advance for your help and guidance!!
Ray Tag: Text it two rows Tag: 86427
Complicated IRR problem
I am trying to create a simple way of calculating the required fina
payment needed to set a stream of uneven cash flows equal to a
inputted IRR. I have created a long manual formula for doing this, bu
it is limited to 8 or so payments before Excel is unable to calculat
the result. For example, let's assume I receive (pay) the followin
cash flows at the following dates:
9/30/04 ($100)
3/31/05 $10
4/23/05 $10
5/20/06 $10
8/25/06 $10
9/30/07 $10
12/31/07 ????
I want to create a formula that will give me the value of ???? at
given IRR. Let's say 15% in this scenario. If I put those dates i
order across row 1 (so that 9/30/04 corresponds to A1 and 12/31/07 t
G1) and put the cash flows in order across row 2, and the discoun
factor (1+15%) in A3, I can solve this problem with the followin
equation:
=(-A2-(B2/A3^((B1-A1)/365))-(C2/A3^((C1-A1)/365))-(D2/A3^((D1-A1)/365))-(E2/A3^((E1-A1)/365))-(F2/A3^((F1-A1)/365)))*A3^((G1-A1)/365)
The result here is $93.3, which gives that stream of cash flows a 15
IRR (you can check with the XIRR function). This gets the job done
but, as I mentioned, it is not possible to easily add payments. Exce
will also stop calculating a result once I get above 8 or 9 payments.
Does anyone have suggestion for a simpler formula (or built i
function) that will solve this? In particular, one that can easily ad
additional payments and can accomodate an unlimited number of payment
(or rather, limited by the cells in Excel).
I notice that this equation can be rewritten as a geometic series, bu
I don't know any way to express this in Excel. I am trying to avoi
using a built-in formula or macros, as this file must be sent aroun
and I do not want to deal with security setting issues.
Any help is much appreciated. Thanks in advance
--
James
-----------------------------------------------------------------------
JamesG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2380
View this thread: http://www.excelforum.com/showthread.php?threadid=51642 Tag: Text it two rows Tag: 86425
Excel Report Writer
Hi All,
I may be crazy, but I thought there was an Access like report writer that
you could add-in to Excel. You could then use an Excel "database" and then
create reports like Access does.
Am I going crazy, or, if not, where do I get this. I think it was a free
add-in.
Thanks
Rich Tag: Text it two rows Tag: 86424
annoying scrolling
I've got an annoyance when using Excel. Sometimes when I attempt to
select a series or rows that extend beyond the size of the screen, my
machine will scroll so fast when I reach the end of the viewed area
that it goes well beyond where I want it to stop. Is there a simple
way to deal with this?
Russ Tag: Text it two rows Tag: 86415
Comparing work books
Hey all,
I have 2 spreadsheets supplied by a customer who tells me they are
the same.
The have around 8000 lines in each and have information in columns A through
to H.
What is the best way to compare these 2 worksheets?
The columns I am interested in the change would be A through to D only. The
rest of the column info is not really important.
Hope someone can help me.
TiA
mag()() Tag: Text it two rows Tag: 86413
Finding amounts on different worksheets
Help please .....
I have been given the task of keeping the accounts [on excel] in order. The
business has the sales client name and figures listed per month on different
worksheets.
When a payment comes in for a specific amount, it would be very useful to go
to a function that could search every worksheet. [All I seem to be able to
do is the methodically do a 'find' on every worksheet]
Is there any way in which the FIND can be used to search every worksheet? Tag: Text it two rows Tag: 86412
Conditional Formatting - formats cells with no data
I have a row of cells that calculate the totals for their columns but I
force to be blank via IF statements until certain conditions are met.
Once these conditions are met, the total appears. I'd like to also
highlight these total cells via conditional formatting. My conditional
formatting input is simply "If Cell is Greater than 0, format". For
some reason all the cells format as though they are all > 0 yet they
don't display anything. Are there some internal rules that specifiy
when a cell is really 0? Is there another way to do this that won't
care what the formula is behind the scenes? All the cells in question
are foratted as "accounting"
Thanks,
Mike Tag: Text it two rows Tag: 86411
SP2 update causes automation crashes
Help!
A client's server was automatically updated to MS Office 2003 SP2 at 3am
this morning. Normally this would be wonderful, but a Windows Service that I
had written, that runs on that server, and that utilizes Excel is now
crashing everytime it tries to open (via automation) a spreadsheet. Aarghhh!
The Event Log says first, "Rejected Safe Mode action: Microsoft Office
Excel."
Next event in the log says, "Faulting application excel.exe, version
11.0.6560.0, stamp 4296b6f2, faulting module mso.dll, version 11.0.6568.0,
stamp 42e18ef6, debug? 0, fault address 0x0003446c."
This applicaiton has been working just flawlessly for over a year, and was
working fine yesterday. As of the update at 3am this morning, it stops
working. I have to assume there's a connection.
Anybody able to give me a clue?
Rob Schripsema
DeWaard and Jones Company Tag: Text it two rows Tag: 86408
Update external links prompt upon opening
I see that Excel 2002 & later allow you to change the startup settings
for updating external links so that you will not be asked and the links
will not be updated automatically. Is there a way to do this in Excel
2000? Tag: Text it two rows Tag: 86407
VBA - Determine last cell in range?
I have a number of rows on an Excel worksheet. I'm writing a macro to loop
through each row and process the info on that row. The number of rows can be
variable.
How do I determine how many rows are in use? When I type CTRL-END, the sheet
knows how many rows to go down. I'd like that capability in my macro.
How I loop now... Which always ends up creating 999 rows, even if I only
have 10 rows of data.
'Create an object to work with our sheet
Set sht = Excel.Sheets(1)
'Loop through all the rows from 11 to 999
For Each fromCell In sht.Range("D11:D999")
Thanks! Tag: Text it two rows Tag: 86402
Copying related values
I can do the following with a macro, but is there any way to do it with
a formula?
On Sheet1, column A contains six digit numbers, like 123456, 314258,
and so on.
On Sheet2, column A contains the same kind of numbers, but not in the
same order, and not necessarily exactly the same numbers.
Those columns need to be matched in the following way:
When row x of Sheet2 has the same A value as row y of Sheet1, then the
value of Sheet2!Bx shall be copied to Sheet1!Cy.
In other words, the value of the second column of Sheet2 shall go to
the third column of Sheet1.
Non matching rows can be ignored.
Thanks for any kind of help
Magnus Tag: Text it two rows Tag: 86397
Need formula for multiple conditions in 3 columns
have a spreadsheet with several columns -- some data, some dates.
Does anyone know how I can create a formula to do the equivalent of
filtering on three
different columns with a different date for each column filtered? For
example I have four columns of information but only want to extract a
certain criteria where as Date A is greater than a specific date, Date
B = another date and Date C = yet another date.
Date A Date B Date C Data
2/12/2001 2/23/2006 3/31/2006 Apples
2/23/2006 1/1/1900 Pears
3/16/2004 2/23/2006 3/31/2006 Peaches
6/15/2005 2/23/2006 6/30/2006 Grapes
For example, I'd like to be able to extract all records where Date A >
1/1/1900 and Date B = 2/23/2006, and Date C = 3/31/2006.
I have Excel 2003
Any help would be greatly appreciated. Tag: Text it two rows Tag: 86396
Problem on opening
I recently got a new computer running Windows XP Home Edition. I installed
my Office 97. Now when I open up any Excel spreadsheet I get a message
saying "A document with the name 'xxxxxxx.xls' is already open. You cannot
open two documents with the same name, even if the documents are in
different folder." This happen every time I open a spreadsheet. If I click
on "OK" the message goes away and I can proceed as normal.
This is more of an annoyance than a problem. How can I put an end to this?
Thanks in advance Tag: Text it two rows Tag: 86391
Formula troubles
I am having trouble getting this formula to work, can anyone help m
out?
This is what I have:
=IF(Z4:AC4,AH4:AJ4={FAIL},"YES","NO")
I am trying to show: If Z4 thru AC4 and AH4 thru AJ4 are equal t
"FAIL" display "YES" otherwise display "NO".
Any help is much appreciated! Biff really hooked me up last time I ha
a formula roadblock...Biff, are you out there?
--
egeorge
-----------------------------------------------------------------------
egeorge4's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3025
View this thread: http://www.excelforum.com/showthread.php?threadid=51629 Tag: Text it two rows Tag: 86387
IF Statement
How can I type a formula for the following:
If the value in cell b4 < 10, round the figure to 1 digit; if the value in
cell b4 is 10 or greater round to 0 digits.
Thank you,
--
Sue Tag: Text it two rows Tag: 86382
pls help me
Hi every body,
I am a new member of this group.
I prepare programms in excel with the help of various functions.
Can any body tell me any way that any person not able to run the excel
sheet if he/she stolen program by any person or staff member for this
private use from my hard disk.
If i give password for opening the workbook. it is not possible because
staff members are working on that program in office.
My staff member copy the programs and misuse it.
Pls help me
Nitin K Goyal Tag: Text it two rows Tag: 86378
Referencing
I am a real Excel novice. Is a reference to a row made only by the
number? Is there anyway to reference a row with a name? If I update
my page from outside Excel and let's say "Apple" which used to be in
row 10 is in row 11 after the update. If I had referenced row 10 from
another sheet for Apple data, do I have to change that reference to row
11 after the update?
Thanks for any info.
--
JHarriman
------------------------------------------------------------------------
JHarriman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31739
View this thread: http://www.excelforum.com/showthread.php?threadid=516226 Tag: Text it two rows Tag: 86377
Pivot table breakdown
I have a pivot table showing a top 10 from a list of 400 and i want to
be able to produce 10 seperate sheets 1 for each of the top 10, I know
i can do it by clicking on the totals but is there a way i can do it so
i can include it in a macro ?
I have tried using pages but this just runs off the whole 400 sites and
kills my machine
I admit i know nothing about VB so the simpler it is the better for me
it will be
Thnx in advance
:)
--
chris.howes
------------------------------------------------------------------------
chris.howes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5660
View this thread: http://www.excelforum.com/showthread.php?threadid=516214 Tag: Text it two rows Tag: 86374
Getting RAND() value but NOT function?!?
Hi everyone,
Say I am using a linear term such as " b * X "; where "b" is a
parameter while "X" is a variable...
Now, assume that "b" is RAND() value and assume I am using an excel
optimizer. When I run the optimizer, it complains that the problem
doesn't satisfy linearity conditions; because RAND() is a function so
it turns "b * X" to become non-linear!!!
I tried to go around this by creating another cell which copy and
value-paste the RAND() value into it. It solves the problem, but now I
have different problem: when RAND() value is copied and value-pased
and, by the time it is put in the new cell, the original cell which has
RAND() function changes its value.....and so on!!
How can I go around this correctly, so I keep the model linear and keep
RAND() values in both cells same?
Thanks,
Mike Tag: Text it two rows Tag: 86373
edit task pane - open a doc
Hi,
Vs 2002 - SP3
I have some documents showing in the task pane under 'open a doc' that
no longer exist.
Is there a way to delete them from the list ?
Many thanks,
Michael
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Text it two rows Tag: 86368
Can I use Excel to create a form?
Hi, Is it possible to make a form by Excel?
I need creat a form which will need users fill some information
such as
Name _____
Address _______
The user can only put information on the line but should not be able to
change the form.
Can Excel do this?
Thanks! Tag: Text it two rows Tag: 86364
Shading protected cells
Using Excel 2003 on Windows XP, I would like to see at a glance which
cells are Locked and which are not, by automatically shading the
background of just the Locked cells. How can I do that?
If that's too hard, is there any other way I can quickly tell which
cells are Locked, for example looking at a status line as I move the
cursor over the cells? or any other way that's faster than opening
Format/Cells/Protection on each cell one at a time?
- Rich Tag: Text it two rows Tag: 86354
Macro or something to manip a string
I'm not the most avid Excel user... though I do use it for tracking alot of
personal finance stuff. One my credit card companies allows me to download
all transactions into a CSV. Works great, but they pick an ugly date
format... "20051213120000[0:GMT]"
As a programmer, I just always run this through a util I wrote that quickly
parses 20051213120000[0:GMT] in to 2005/12/13 and throws the rest away. I
was just wondering if there was a way within Excel to convert it. The date
stamp they give always follows that format. i.e. "YYYYMMDDxxxxxxxxxxxxx" I
don't care about what is in the x's.
I'm sure there is some way to do this in excel. Just not finding the
"Help" very helpful... though I probably don't know how word it properly to
find what I am looking for. Tag: Text it two rows Tag: 86351
Error: This Web query returned no data
Hi all.
I'm having problems importing data from my own ASP.NET web site into
Excel. I create a new Web Query and enter the URL, and my data page
shows OK. I select the table in which I am interested from the window
below, but when I click Import, I get the error message:
"This Web Query returned no data. To modify the query, click OK, click
the name of the external data range in the name box on the formula bar,
and then click Edit Query on the External Data toolbar."
Agh! What is wrong here? How come it can see the data in the dialog
box, but when I come to actually import to the sheet it fails?
Selecting the entire page instead of the single table also makes no
difference.
I have been doing this from an ASP page for a long time now with no
problems. Now I have upgraded the page to ASP.NET it no longer works.
There is no password on the site. I am thinking it could have something
to do with cookies, but I am not sure.
I have seen this support page, but it doesn't help in my case:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q277596
Any help very much appreciated.
Mike Tag: Text it two rows Tag: 86349
diverting output
hello,
how do i make a function in one cell alter the value of another cell?
i would like to do the following:
if cell1 equals "test string" then make cell(3 + value of cell2)
increment by 1
the reason why i can't put the function in the output cell is because
the range of output cells is the same target for a whole bunch of these
functions.
-az Tag: Text it two rows Tag: 86342
How to Save an Excel file using VBA
Hi All,
I have a tool called "TestPartner" which uses VBA to test the
applications.
My application opens an Excel file after submitting the data. Now,
using the VBA in TestPartner I have to save that file.
Following is the code written by me.
Dim myExc As Object
Dim myWb As Workbook
Set myExc = CreateObject("Excel.Application")
Set myWb = Excel.ActiveWorkbook
myWb.SaveAs ("Path")
but this is not working.
Please let me know how to save the Excel file which is already opened
using VBA.
Thanks,
Suraj Tag: Text it two rows Tag: 86335
No minimize/maximize option in title bar?
The buttons for minimize/maximize/close are not showing up on the titl
bar. Why might this be
--
conks
-----------------------------------------------------------------------
conksu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3187
View this thread: http://www.excelforum.com/showthread.php?threadid=51600 Tag: Text it two rows Tag: 86331
Interesting Calculation
Hello,
I have a 2006 calendar in Excel that I have downloaded from the Office
Templates website. I've taken the calendar and added it to a budget
spreadsheet I'm building.
What I want to do is be able to type in "House Payment: 1200.00" on
March 2nd and "Car Payment: 400.00" on March 15th, for example, and be
able to calculate those amounts in another field.
This means that I need to be able to sum fields that contain numbers
and text. Is this possible?
Thanks!
Dale
--
flipknob
------------------------------------------------------------------------
flipknob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31871
View this thread: http://www.excelforum.com/showthread.php?threadid=515996 Tag: Text it two rows Tag: 86330
Mail merge - Multiple entries
If I want to do a mail merge, merging excel entries in word, how can I
included multiple entries per identifier? For example, if I had a list
of airline tickets matched with ID numbers and I wanted to send one
email with all airline tickets matched with their ID number, how would
I do that? Is there some kind of loop I can do?
--
conksu
------------------------------------------------------------------------
conksu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31870
View this thread: http://www.excelforum.com/showthread.php?threadid=515995 Tag: Text it two rows Tag: 86329
formatting cells based on comparison
I have 5 date colums.
I was wanting to change the background of cells 2-5 based on if they
are equal to cell 1 value
date1 date2 date3 date4 date5
12/01/05 12/16/05 12/01/05
here since date3 = date1 date3 would have a yellow background.
how do you do Conditional Formatting on something like this?
thank you for any pointers for a noob
Jerry Tag: Text it two rows Tag: 86325
obtaining data from a list
I need to get some values from a list but I don't want to sort or filte
the list. I want a user in input some values and I want to obtain
value in the list based on what was entered. Then I want to use tha
value in other calculations. Also the list is formatted like this:
material thk lbs/sqft
cs 3/16 7.66
cs 1/4 10.2
cs 5/16 12.8
cs 3/8 15.3
cs 7/16 17.9
ss 14 ga 3.15
ss 10 ga 5.67
ss 3/16 8.58
and I want to get the lbs/sqft based on the first 2 columns.
So the input would be cs and 5/16 I need to get 12.8 and put that int
a cell where I can use it. Also I would prefer the user to not see thi
list.
I would like to have a pull down for the first column and then based o
what is chosen have a pull down for the second column but have only th
values shown that correspond to the first column. then when a value i
chosen in column 2 the correct value for column 3 would appear.
Is this possible?? I have pulled my hair out trying
--
vencopbras
-----------------------------------------------------------------------
vencopbrass's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3186
View this thread: http://www.excelforum.com/showthread.php?threadid=51596 Tag: Text it two rows Tag: 86321
What do I need to sort, sum this data?
I have a spreadsheet which tracks the fluids and lubricants added to a fleet
of vehicles. Each entry contains the location, type of additive, quantity,
and unit of measurement (ounces, quarts, gallons). I need a single table
that shows each type of additive broken out by location added, with a sum of
how much was added at that location. Since my 10-foot-pole is working, I
guess I'd better ask how best to approach this?
Ed Tag: Text it two rows Tag: 86313
Link Page Fields to separate Pivot Tables
Is it possible to link the page fields for two different Pivot Tables so
that when one page field is changed it updates the other also?
I'm sure this is a common question(I did try and search!) and the
solution is probably simple but I cannot seem to get it.
Thanks.
--
xunzi
------------------------------------------------------------------------
xunzi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31195
View this thread: http://www.excelforum.com/showthread.php?threadid=515893 Tag: Text it two rows Tag: 86309
Sorting by number in a non-numeric field
Hi guys.. so question..
Say I have a row with example:
Building1-PC1
Building2-PC1
Building3-PC1
Building1-PC2
Building2-PC2
Building3-PC3
Building1-PC100
Building2-PC100
Building3-PC100..
Desired result from a sort..
Building1-PC1
Building1-PC2
Building1-PC3
Building2-PC1
Building2-PC2
Building2-PC3
Building3-PC1
Building3-PC2
Building3PC-3
Now how do I get there? :P
--
kronik
------------------------------------------------------------------------
kronik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31541
View this thread: http://www.excelforum.com/showthread.php?threadid=515861 Tag: Text it two rows Tag: 86305
If formula nesting
Does any one know if there is a limited number of arguments one can nest
in an IF formula? I have tried entering 14 conditions and it will not
accept after the 8th one. It tells me I have no false value. Or is
there something wrong with my formula?
=IF(H45=43.9,
"Needles",IF(H45=21.95,"Needles",IF(H45=62.5,"HP",IF(H45=65,"HP",IF(H45=67.5,"HP",IF(H45=70,"HP",IF(H45=130,"HP",IF(H45=135,"HP",if(h45=140,"HP",if(h34=995,"CD",if(h34=1295,"CD",if(h34=1695,"CD",if(H34=1990,"CD",if(h34=2190,"CD","
"))))))))))))))
--
ccraig61
------------------------------------------------------------------------
ccraig61's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31856
View this thread: http://www.excelforum.com/showthread.php?threadid=515829 Tag: Text it two rows Tag: 86298
Link to a cell and text in same cell
My Sheet:
A1= BOB
I want B1 to equal the value in A1 and additonal normal formatted text so it
would read "BOB's Total". I've searched all thru the help and cant find a
good example to lead me into anything like this.
Anyone have any ideas?
::CORY:: Tag: Text it two rows Tag: 86295
Problem with Worksheet in the migration .NET 2005 Beta 2 To .NET 2005
hello:
I had installed .NET 2005 Beta 2.
I have a project of excel and this book of excel has many worksheets. By each sheet I mad=
e a class. In the Hoja1_Initialize method of the Hoja1 class, I call to another method=
that it has like parameter a Excel.Worksheet type.
When I call this method: generate(this), "this" in .NET 2005 Beta is a active sheet(H=
oja1), but when I installed .NET version 2005, its dont work. "this" is the Hoja1 clas=
s, no the active sheet(Hoja1).
So, I call method thus:
this.Activate();
Hoja1Class.getInstance().generate((Excel.Worksheet)this.Application.Act=
iveSheet);
This works, but when I do this:
((Excel.Range)sheet.Cells[i, j + 1]).Formula =3D formulaC;
generate Excpetion: =
{"Exception from HRESULT: 0x800A03EC"}
Server stack trace: =
Exception rethrown at [0]: =
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessag=
e reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& m=
sgData, Int32 type)
at Microsoft.Office.Interop.Excel.Range.set_Formula(Object )
at boletin.classes.Hoja1Class.print(DataView saldosTotales, Worksheet sheet=
) in C:\Proyectos Marce\boletin\boletin\classes\Hoja1Class.cs:line 196
at boletin.classes.Hoja1Class.generate(Worksheet sheet) in C:\Proyectos Marc=
e\boletin\boletin\classes\Hoja1Class.cs:line 301
at boletin.Hoja1.Hoja1_Initialize(Object sender, EventArgs e) in C:\Proyectos=
Marce\boletin\boletin\Hoja1.cs:line 43
at Microsoft.Office.Tools.Excel.Worksheet.OnStartup()
at boletin.Hoja1.FinishInitialization() in C:\Proyectos Marce\boletin\bolet=
in\Hoja1.Designer.cs:line 61
at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInt=
ernal.ExecutePhase(String methodName)
at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInt=
ernal.ExecuteCustomizationStartupCode()
at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInt=
ernal.ExecuteCustomization(IHostServiceProvider serviceProvider)
I don=C2=B4t know to do, Somebody Can I help me? Tag: Text it two rows Tag: 86292
Hi all
How do I set a cell to behave like a textbox?
I want to be able to use the enter key to go to the next line.
Thanks
Guy
"Guy Cohen" <noemail@please.com> wrote in message
news:OOpYHAtOGHA.2268@TK2MSFTNGP09.phx.gbl...
> Hi all
> How do I set a cell to behave like a textbox?
> I want to be able to use the enter key to go to the next line.
> Thanks
> Guy
>
I'm not quite sure what you mean but holding down alt and enter will create
a new line.