How do you sort a multi-column list by rows?
I'm a worship leader, I need to create an index for the songs in my notebook.
I'm using Excel (I'm an absolute beginner, just got it yesterday) and need
to know how to sort a list with several columns (song title, tempo etc.) by
any one of the columns and keep the rows intact. Thanks 4 the help.
If I understood your problem correctly, this should help, at least a bit.
Select ONE cell in the column you want to sort by. Then click on a button in
the toolbar, it should say AZ and an arrow downwards. To do an ascending
sort, click the button with and arrow upwards.
If you don&...Need single column/row of numbers to print down then across pages in order
I have a very long list of phone numbers that occupies
a1,a2, so on. approx. 45,000 records. I need to be able
to print hard copies of these numbers so that it stays in
order from page to page but is not just one column. (as
to cut the # of pages from 300 to 50 or lesss) In other
words, start in the top left corner of page through to
bottom, next row, and so on. I thought there would be a
way to set this up in printing options but to this point
haven't figured it out. I have the same list (1 row
again) also in Access if it would be easier. Would VERY
much appreciate any clu...Drag n' Drop emails to a Java application
We are developing a Java application where we want to import information
received in e-mails. The email client are Outlook 2003 (at least for
now). The best way would be to be able to drag the e-mail to the Java
app and then access/parse the e-mail in the Java app.
I have searched the web but can not find anything useful.
Do I have to use COM and/or OLE for doing such operations?
Please help me!!
...Inserting rows #9
I copied a 2004 spreadsheet to use for 2005, the new will not let me insert
rows, the orig. did. Could I have done wrong,in the copying. I am not aware
of different copying methods. Did I use A wrong format?. I have read a great
deal on this to no resolve. Can someone help me?
What message do you get when trying to add a row?
Is its message saying that Excel will not shift data off the sheet, or does
it ask for a password?
For the former, hit Ctrl and End together and note the last used cell in the
sheet. DELETE, not 'Clear Contents ' all rows below that row, save the...Put Results in another cell
OK guys/gals -
I know this MUST be simple, but I'm very new to excel.
I'm trying to look at one column (A), if the work "Dist" or "Sale" is in the
Cell, I would like to fill the next column (B) with "--", otherwise, leave
the values alone in column B.
=IF(OR(A1="Dist",A1="Sale"),B1="'--", otherwise leave value alone in B1
Thanks for everything!
To clarify, I would like my formula to reside in column (B), but there is
other info already in that column. If the condition in column (A) is met,
then (B) must change, ot...Drag and drop with CRichEditCtrl
I have an application that makes heavy use of the rich edit control.
One of the things I needed to do was to customize text when it is
pasted or dropped onto the rich edit control. This wasn't too hard to
do: I have an object implementing IRichEditOleCallback attached to the
rich edit, and in the QueryAcceptData() method I modify the data as
needed before adding it to the control.
My problem comes with drag and drop, specifically with the "move" drop
operation. Following the MSDN documentation, my QueryAcceptData()
method returns S_FALSE to indicate that it's processed the d...Splitting Cells #2
I have a pdf with tables of data. I converted it to Word with Acrobat. The
data for each column is in one cell. Ex: All the costs for each item is in 1
column - but 1 cell instead of 1 column several cells. When I copy and paste
to excel it does the same thing. (Each column of data in one cell.) Is there
a way in excel to search for a space and replace with split cells. And the
document is 58 pages long.
Jess, click on Data, Text to columns, Delimited and click on space then
finish. This should do it.
"Jess" <Jess@discussions.microsoft.com> wrote in message ...Using Texts in Cells
I have a list of parts numbers (alphabetical and numeric) and want to use
these in a sum.
How can I include these in a sum eg if C1= EV1, C2=EV2?
Alternatively if not possible can I use the SUBSTITUTE function to pick this
text from a list
Thanks in advance
do you wnat to do a sum or a count?
if a count, check the countif() function in help
> I have a list of parts numbers (alphabetical and numeric) and want to use
> these in a sum.
> How can I include these in a sum eg if C1= EV1, C2=EV2?
> Alternatively if not possible can I use the SUBSTITUTE func...Drop Down list with colours
Is there any way in Excel to create a drop down list which contains colours?
For example to show RAG status (i.e. Red Amber Green).
At the moment I can only show text in the drop down list.
Would anyone know a way of working around this?
Thanks Roger, and Chip, for replying.
I was playing around with it and found that I could conditionally format the
cell depending on the text selected - so if I choose "RED" it goes red. It's
just about enough to work for what I intend to use it for, but I'll
experiment with your suggestion in case I need to develop thi...Auto insert tab name in cell
Is there a function to use the Tabname or sheetname in a cell?
Use the following formula:
The file must have been saved for this to work.
"Norm" <email@example.com> wrote in message
> Is there a function to use the Tabname or sheetname in a cell?
Chip Pearson wrote:
> Use the following formula:
> =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))...Drop Downs and lookups from other sheets
I have a workbook where the front sheet is a display page and the three
sheets behind are reserved for data tables. What I want to do is have one
cell in the front page which is a drop down and selects names from one of the
tables on the other sheets. From there I can use Vlookup to populate the
info from the tables on the front page based on that name. The problem is I
can't seem to get this list of names from another sheet. Every time I try, I
get an error. How would I do this? thanks!
first insert a name for your list in the other sheet, go to insert, name, ...how do I change the lerrers in the header of each cell to a name?
I am trying to create a spreadsheet that names or at least name the
firstcell so that it will be present even when I scroll down . is this
I think you are talking about Freeze Panes. Select cell A2, assuming you
have headers or whatever in A1, then click on Windows - Freeze Panes. Now
scroll down and you will see that row 1 stays visible at all times. Is this
what you want? HTH Otto
"robush3" <firstname.lastname@example.org> wrote in message
>I am trying to create a spreadsheet that names o...Drop-down data not appearing in exported XML
I'm exporting data as XML from an Excel spreadsheet. Cells with plain
text in them work fine, but cells with a selection from a drop-down list do
not. The XML file shows everything is there, except data from cells with
drop-down selections. No error message generated, just no trace of the data.
Fixed the problem. Found out that the drop-downs were actually objects
placed on top of the cell, the options were not coded into the cells
"Kristi" <kristi@NOSPAMinscriber.com> wrote in message
> ...Drop down list #8
I created a drop down list using the data, validation menu. It works well.
However, I only have two items in the list and I am wondering if there is a
better way to alternate between them. With the drop down list it takes a
couple of clicks. First you select the cell, then you click to drop down the
list, then you highlight the item, then you click on it.
Is there a way to select the alternate item with fewer clicks?
You need only click the cell, click the dropdown button, then click the desired item. Three
This event-fired sub will alternate between "Choice a&qu...dragging array UDFs
Hi I built an array function and it is working well. However when I dra
it to other cel regions I got the message "VALUE". The exact formul
and the code is below.
Thanks for any help.
Code: x is a sorted array.
Public Function samLMR(x As Variant, Optional a As Double = 0#
Optional b As Double = 0#) As Variant
Dim xmom() As Double
Dim xm() As Double
Dim sum(8) As Double
Dim R As Integer
Dim C As Integer
Dim ReturnColumn As Boolean
R = Selection.Rows.Count
C = Selection.Columns.Count
n = x.Count
n = n - nfails
If R < C Then
nm...My Drag Image Flickers
My drag image flickers, I understand the cause of this (I think) but I don't
know how to fix it.
I use this to auto-scroll during a drag and drop:
// in OnTimer()
So since I'm hiding it, then showing it again, it flickers. Can I fix this ?
...Convert multiple rows of text into columns...
I have rows of text and figures that I need to separate into columns. Excel
2003 will only let me do one row at a time. Is there an add-on that will
allow me to convert multiple rows?
There are various methods.....worksheet functions or macros.
If we had a representative sample of your data layout and what you want done
with it we could make a better decision.
Gord Dibben MS Excel MVP
On Sat, 10 Mar 2007 15:32:23 -0600, "silas" <silas.NOSPAMprophet@gmail.com>
>I have rows of text and figures that I need to separate into columns. Excel...Repost: Copy and Offset cell reference
I posted this a couple of days ago, but I missed the functions group, no
I was asked if this was possible and I can not think of how, hopefully,
somebody can help me.
On Sheet 2, I have the following data:
cell B2 =sheet1$N$14
cell B3 =sheet1$N$32
On sheet 3, I need to have
cell B2 =sheet1$N$15
cell B3 =sheet1$N$33
On sheet 4, I need to have
cell B2 =sheet1$N$16
cell B3 =sheet1$N$34
Basically, each sheet is a different month and the references need to
be offset each time. This needs to be done a number of times in this
and other workbooks.
Is there an efficie...how do I set up a header or a footer in the dropping down menu to.
I am trying to set up a footer that I can use throughout many workbooks, just
not the sheets. Is there a way do this by setting it up as a predetermined
footer or header in the drop down menu
You can use a template for new workbooks and new sheets that includes the
headers and footers you want. See Help for more information. But this will
affect only new workbooks and worksheets, not existing ones. For them, you'll
have to change each one manually.
On Tue, 19 Oct 2004 12:03:05 -0700, Chrisanna
>I am trying to set up a footer that ...Drag and Drop Emails
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
Within entourage, when I drag and drop an email from my inbox to another folder, it "copy/pastes" it instead of moving it permanently so it stays in the original location where I was trying to move it from. Seems the only way around this is to right click on the email and select "Move to" and then select a folder (but I have dozens of folders and this is not quick at all). <br><br>Is there a way to change my settings so when I drag and drop emails, it's a &am...Insert Rows into an existing array
I have a spreadsheet with a series of formulas in various columns. I now want
to insert more rows that will follow the formula rules of the existing
columns. How do I overcome the message "you cannot change part of an array"?
Thanks in advance
Go to the cells that have the array entered formula, select them, enter edit
mode (when the first cell is the active cell), press home, and insert a
single quote, then press Ctrl-Enter (not Ctrl0Shift-Enter). Do this for all
multi-cell array formulas. Then insert your rows, then reselect the cells
(plus extra for the newly inserted ...Align & Compare row with column
A1: USB 2.0, B1: USB, C1: Type A
A2: FW, B2: FW400
A3: Serial, B3: DB-9, C3: RS-232
I have another list.
G1: USB 2.0
What I want is to sort A1:C3 row wise, and it will compare with column
F,G & H.
if column F matched with row1 then a particular value should be
In other words no matter what data lies in A1:A4....its order should
be like F1:H1
Thanks in advance.
If I understand you correctly, HLOOKUP is the way to go.
In A1 type =F1 and copy this through to column C
In A2 type =IF(HLOOK...copy cell format?
I have two worksheets. One I use to insert data, the other to summariz
the data I entered. On the data sheet, I have a few items that ar
I'm using ='data'!b2 to copy the cell contents from the data sheet int
the summary sheet, it copies the content, but not the forma
How can I correct this?
Ltat42a's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2473
View this thread: http://www.excelforum.com/showthread.php?threadid=49803
Formulas can only r...Trying to drop MSCRMDistribution table
I'm trying to delete the CRM tables from SQL, but keep getting "Error 3724:
Cannot drop the database because it is being used for replication.". I ran
sp_removedbreplication against all of them, and I was able to delete the
first three, but the MSCRMDistribution table is still there. The database
icon in Enterprise Manager does not have a hand underneath, so I'm not sure
why I'm getting this error. How can I drop this table?
In case anyone is wondering why I'm doing this, I attempted to install CRM
earlier this week, but things went astray with the IIS setti...delete rows with header, excluding 1st row
Headers are repeated several times between rows A1:A1000.
Need to delete all rows where header "DAY" is in column A, except for
the first instance (A1).
try code like the following:
Dim N As Long
N = .Cells(.Rows.Count, "A").End(xlUp).Row
Do Until N = 1
If StrComp(.Cells(N, "A"), "DAY", vbTextCompare) = 0 Then
N = N - 1
Microsoft Most Valuable Professional,
Excel, 1998 - 2010